Yes, you just call VLOOKUP twice, once for each cell, with the same lookup
value, same lookup table, but use a different column offset in each VLOOKUP

--
HTH

Bob Phillips

"Julian Campbell" wrote in message
...
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