Using Pick Lists
 

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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


Awetronics wrote:
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