Place a set value in a cell from a drop down list name reference
 

I would like to have a dropdown list with an array of name values. When a
user selects on of these names a value (such as price) is then put into a
certain cell.

Alan

See Debra Dalgleish's site for using VLOOKUP with Data Validation drop-down
pick lists.

DV basics.. http://www.contextures.on.ca/xlDataVal01.html

VLOOKUP basics.. http://www.contextures.on.ca/xlFunctions02.html

Gord Dibben Excel MVP

On Fri, 5 Nov 2004 14:39:01 -0800, "Alan Lipscomb" <Alan
wrote:

I would like to have a dropdown list with an array of name values. When a
user selects on of these names a value (such as price) is then put into a
certain cell.