I would think that if you used two =vlookup()'s, it would be more
straightforward:
=vlookup(a1,sheet2!a:c,2,false)
and
=vlookup(a1,sheet2!a:c,3,false)
But you could use an array formula if you wanted.
Select the two cells (B1:C1???) and use this:
=vlookup(a1,sheet2!a:c,{2,3},false)
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
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
--
Dave Peterson
|