View Single Post
  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

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