Using Pick Lists

[Awetronics]

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

 

[Bob Phillips]

Mark,

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

--

HTH

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

 

[Frank Kabel]

Hi
use 'Data - Validation' in combination with vLOOKUP. See:
http://www.contextures.com/xlDataVal01.html
http://www.contextures.com/xlFunctions02.html