Mark,

Data Validation with list - see http://www.contextures.com/xlDataVal01.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Awetronics" wrote in message
...
Hi-
I need to use a pick list that will also reference other cells attached to
that list. For example, I want to create a database of products und use a
pick list to select one specific item but with it a description and a
price.
Thanks in advance,
Mark