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
Who is Participating?
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:


Hope you understand the general idea.

Amit KhilnaneyCommented:
I guess you have to use traditional way

If else statement ..

Open in new window

BellscapeAuthor Commented:
What I was after
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.