Special lookup
 

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

Special lookup
 

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.

"Fred Blair" wrote:

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