Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help With Linking Drop Down Boxes | Excel Discussion (Misc queries) | |||
Linking Drop Down Boxes | Excel Discussion (Misc queries) | |||
Linking Drop Down List | Excel Worksheet Functions | |||
Linking Drop-down options | Excel Discussion (Misc queries) | |||
Drop down list linking | Excel Worksheet Functions |