How do I reference multiple rows

[Awetronics]

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

 

[Gord Dibben]

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