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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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