vlookup x 2
 

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

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

Sure, Julian. You can see a tutorial/sample he
http://www.officearticles.com/tutori...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"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

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

Julian,

basicaly, without using VB code, you cannot 'put' something into
another cell, the formula must be within the cell and the result of the
formula is shown within the cell.

You can, however, use two VLookups, one in each cell.

=vlookup(item,tablerange,2,false)
and
=vlookup(item,tablerange,3,false)

Hope this helps



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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=470077