vlookup x 2

[Julian Campbell]

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

 

[Bob Phillips]

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

 

[Anne Troy]

Sure, Julian. You can see a tutorial/sample here:
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

 

[Debra Dalgleish]

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 here:

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

And instructions for an order form with VLookups here:

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

 

[Bryan Hessey]

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