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

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.

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

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



"Blaize" wrote:

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.

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

Brilliant and quick, glad you understood what I meant, thank you very much!

"ck" wrote:

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



"Blaize" wrote:

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.