Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare two lists of names in excel? | Excel Discussion (Misc queries) | |||
Pick From List | Excel Discussion (Misc queries) | |||
Data Validation Lists | Links and Linking in Excel | |||
Aligning Two Lists in Excel | Excel Discussion (Misc queries) | |||
comapre two lists | Excel Discussion (Misc queries) |