DropDown Lists in Excel

I have an excel spreadsheet that uses drop down lists to select specific items, I would like to it to autofill certain cells with set figured when a particular item is selected from the drop down list.

EG.  A spreadsheet that has a list of cars and when you selct a certain make it autofills cells for manufacturer, year, body type etc.

Has anyone got any ideas on how to do this.

Thanks in advance
LVL 1
BellscapeAsked:
Who is Participating?
 
jppintoCommented:
You need to use a Vlookup function to get the corresponding data to show up on the fields.

I've attached a sample file. When you select a name on column B, it autofills the column A with the corresponding employee number using a formula like this:

=IF(B2<>0,VLOOKUP(B2,Listagem!$A$1:$B$12,2,FALSE),"")

Hope you understand the general idea.

jppinto
VLOOKUP-6.xlsx
0
 
Amit KhilnaneyCommented:
I guess you have to use traditional way

If else statement ..
http://office.microsoft.com/en-gb/excel-help/use-conditional-formulas-in-excel-to-analyze-financial-data-HA001091832.aspx

Open in new window

0
 
BellscapeAuthor Commented:
What I was after
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.