You can do this with a data validation list in the first column, and
VLookup formulas in the adjacent columns.

There are instructions and an example he

http://www.contextures.com/xlOrderForm01.html


Victoria_Wells wrote:
Hi there

I am really struggling with a list. Basically, I have 3 colums, Product,
Unit & Price.
I want to create a drop down list which allows me to select multiple rows
for a quote, but pulls in all 3 columns, therefore giving me the product
name, the unit it is sold in and the cost per unit, without me having to type
it in everytime. It absoloutely needs to have all 3 columns included, it is
not an option to put everything into 1 column. Is this possible?




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html