ExcelBanter - Linking Drop Down Box

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Linking Drop Down Box (https://www.excelbanter.com/excel-discussion-misc-queries/204892-linking-drop-down-box.html)

Joey

Linking Drop Down Box

I created a drop down box with 9 items. What I want to do is after the user
selects one of the 9 items, a price will show in the adjacent cell
corresponding to that chosen item.

I tried to use the IF function, but it works up to 8 items only. I used
if(A1=A3,B3,if(A1=A4,B4,if(A1=A5,B5,if(A1=A6,B6,if (A1=A7,B7,if(A1=A8,B8,0))))))

Is there any other method that I can use to accomplish this goal?

JMB

Linking Drop Down Box

try:
=Vlookup(A1, A3:B10, 2, 0)

"Joey" wrote:

I created a drop down box with 9 items. What I want to do is after the user
selects one of the 9 items, a price will show in the adjacent cell
corresponding to that chosen item.

I tried to use the IF function, but it works up to 8 items only. I used
if(A1=A3,B3,if(A1=A4,B4,if(A1=A5,B5,if(A1=A6,B6,if (A1=A7,B7,if(A1=A8,B8,0))))))

Is there any other method that I can use to accomplish this goal?

All times are GMT +1. The time now is 05:38 PM.