Use a VLookup formula in the second column, and another Vlookup formula
in the third column. There are instructions for Vlookup in Excel's Help,
and he

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

And instructions for an order form with VLookups he

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

Julian Campbell wrote:
Hello all,

I have set up a vlookup with help from this group.

I wonder if I can use vlookup to return 2 entries, each into seperate cells

1 2
3

A SELECT RETURN VAL 1 RETURN VAL 2
PRODUCT PRODUCT CODE PRODUCT PRICE

Thanks again for your help

Julian




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html