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