Previous Topic Next Topic

Look up two criteria and return one value

Closed
officemanager - Apr 17, 2010 at 01:01 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 17, 2010 at 02:01 PM
Hi

I'm trying to do a vlookup to look up a PO number in a 2nd spreadsheet which contains the sage output of PO number / amount / invoice no/ date and

In spreadsheet A look up PO number and invoice amount (in separate columns) and then return the corresponding value from spreadsheet 2.

Any ideas


1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Apr 17, 2010 at 02:01 PM
Most easy and efficient way would be to add a working column to combine the two column in the lookup table

then you can use lookup as for example

=vlookup(A2 & B2, sheet2!A:f, 5, true)
0