Excel Drop Down Menu

March 17, 2009 at 10:14:51
Specs: Windows XP, 1.0 Gb

I'm trying to contruct a drop-down menu in Excel. The menu needs to include 10 names and their respective titles. This menu would be coped 10 times, in each of 10 selected cells. Once a name is selected, other cells will be automatically filled in. For example, if the drop-down menu selects a name that goes into cell A1, I can then use an IF statement to get the appropriate information for that person into their appropriate cells.

The drop-down menu is needed because there isn't any particular order in which the name are entered into the spreadsheet. Because of this, I would need many IF/OR statements so that the correct data is matched up with the correct name.

Thank you.


See More: Excel Drop Down Menu

Report •


#1
March 17, 2009 at 11:15:22

Are you asking for the instructions on how to create a dropdown?

Dropdowns are created using Data...Validation...Allow: List

In the Range that makes up the List, you would put the selections for the dropdown.

By using Named Ranges and the INDIRECT function, you can then populate other Dropdowns with different data depending on which item is selected in the first Dropdown.

Does that help?


Report •

#2
March 17, 2009 at 13:50:04

Thank you for your quick response; I was able to make the drop down menu I needed based upon your reply.

Report •

Related Solutions


Ask Question