Drop Box

J

Justin Mamulis

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?
 
A

Alan

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.
 
Top