Dropdown box to display data in other cells

[breit]

Hi,

i want to make a excel sheet that has a drop down box listing catagories which once selected showed data in the cell next to the dropdown box.

eg, select freight, displays john doe and the phone number. (the data will be stored on the same sheet.

thanks

[JBeaucaire]

Data Validation and Name ranges for the drop downs.

INDEX/MATCH for bringing data out of a database next to your drop down value.

Here's some sample sheets showing exactly what you're looking to do.

Jerry Beaucaire's Excel Tools

(The files you want are INDEXMATCH-Simple.xls and INDEX-MATCH-Sample.xls)


Everything you need is in those files, so give it a shot. If you get stuck, come back and post your workbook with how far you've gotten and we'll help.

[gibsongk55]

Wow this is exactly what i need to know but I don't see an answer here. I checked the two samples but i don't see the answer in them either.

Gibs