Special lookup

F

Fred Blair

Is there a way to put a drop down list into a cell and then, when a list
item is selected, then the lookup goes to the lookup area and pick the
corresponding value to use in another cell.

Fred
 
J

JMay

You could use Data Validation for your Drop Down Cells; then in the adjacent
cell enter a VLookUp() formula, referring to the Lookup Value from the Drop
Down to bring back the proper Offset from a table.
 
Top