Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop Box
I created a drop box with various product choices in it. How do I get the
two cells next to the drop box cell, headed Description, and Unit price to change accordingly to what is selected in the drop box? |
#2
|
|||
|
|||
Assuming you've used a ComboBox from the Forms Toolbar, if you right click
it and select 'Properties' you'll see a window marked 'Link Cell' This cell will show the position of each item in your range, that is if you select the first item at the top it will display 1, the second will display 2 etc. If for example you set this cell to A1 you can use in the next cell something like =VLOOKUP(A1,your range containing Description,2,FALSE) Regards, Alan. "Justin Mamulis" <Justin wrote in message ... I created a drop box with various product choices in it. How do I get the two cells next to the drop box cell, headed Description, and Unit price to change accordingly to what is selected in the drop box? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas for drop down menus | Excel Discussion (Misc queries) | |||
How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Filling drop down box | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |