Special lookup

  • Thread starter Thread starter Fred Blair
  • Start date Start date
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
 
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.
 
Back
Top