V lookup but with 2 columns, so what formula?

**Megan619** · 06-15-2012, 03:08 PM

mock excel sheet upload.xlsx

See attachment, trying to figure out a formula for Sheet one where you can get the backorderd quanity from sheet 2 by looking up that number from searching PO number and Item # and placing it in the right cell in sheet 1!!! I am familiar with Vlookup formula, But for this instant you cannot use it because it is two values (columns) I want to look up! PLEASE HELP.

**Megan619** · 06-15-2012, 03:11 PM

I am pretty sure it is a SUMIFS formula but I don't know how to apply it

**K m** · 06-19-2012, 03:52 PM

I'm not sure what you are really asking but this formula works:
In cell C4 enter the following formula
=IF(ISNA(VLOOKUP(D$3,Sheet2!$D$4:$P$17,13,FALSE)),"",VLOOKUP(D3,Sheet2!$D$4:$P$17,13,FALSE))
Copy the formula to the right to column X

The first part of the formula takes care of a "non match",
the rest of the formula does a "regular" lookup

=====================
If this solves your problem. Change the title to include [SOLVED]
and please click on the star at the bottom of this message

Kirk