How to make items in a drop down menu reference a number

B

Blaize

So, I'm using Excel 2007, and I have made a drop down menu with certain items
in it. I want to make it so that when I select an item from the drop down
menu, a number appears in a seperate column depending on which item I chose
in the drop down menu. Hope that made sense, thanks for reading.
 
C

ck

Not sure if i understand correctly. Assuming the following: Column A is the
database of items and column B is the numbers that you want to reference.
Column D is where your drop down menu is and E is the place where you want
the numbers to appear

A B C D E
1 new 5 new 5
2 car 10 boy 15
3 boy 15 this 20
4 this 20 new 5

In E1, paste this formula =INDEX($B$1:$B$4,MATCH(D1,$A$1:$A$4,0)) change the
necessary range and drag down.

Click yes below if this is what you want
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top