Drop down menu/formulas

thomas@usethesystem.com

From a drop down menu I need the three rows beside that are numbers, to self populate depending on what is selected from the drop down menu.

Please help, thank you...

Drop down to self populate.png

Andrée Starå

Hi Thomas,

You'd need to add the information that you want to populate in a table in the same sheet or another sheet, and then you'd use either a VLOOKUP or INDEX/MATCH formula to populate it when the dropdown value is selected.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

thomas@usethesystem.com

Thank you so much.....very kind. Be safe and all the best in these crazy times.

thomas@usethesystem.com

I will give it a try in the morning....

Andrée Starå

Thomas,

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!