How do I reference multiple rows
 

I need to create a list and reference multiple cells to a row or column in
that list, preferably using a pick list. More specifically, I have an invoice
and I want to select a specific product and have the data for that product
reference the cells following.
Item Description Price
Dropdown Reference previous selection Reference following

I want this to be done with excel, please help!
Mark

Mark

See Debra Dalgleish's site for using VLOOKUP with Data Validation drop-down
pick lists.

DV basics.. http://www.contextures.on.ca/xlDataVal01.html

VLOOKUP basics.. http://www.contextures.on.ca/xlFunctions02.html

Gord Dibben Excel MVP

On Wed, 3 Nov 2004 10:40:02 -0800, "Awetronics"
wrote:

I need to create a list and reference multiple cells to a row or column in
that list, preferably using a pick list. More specifically, I have an invoice
and I want to select a specific product and have the data for that product
reference the cells following.
Item Description Price
Dropdown Reference previous selection Reference following

I want this to be done with excel, please help!
Mark