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

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

Yes, by entering VLOOKUP formulae in both cells, referring to different
column in the lookup range.

--
Ian
--
"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