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