Comparing Open Orders - What to use? VLookup within VLookup?

[benjamin09]

Hi, I've been trying to figure this out for a few hours using different ways but maybe there isn't away.

What I am trying to do is compare my open orders for a company vs the customers. Attached is the sheet with 2 tabs, labeled one for theirs and one for my reports. On their tab I'm trying to verify that they have it on order and our quantities match up. Since the same items are on multiple orders, is there a formula to find them within different PO numbers? I've tried researching this or trying to find a way to do it but have had no luck.

Thank you very much for any help or letting me know if it is possible.

[RudiS]

Hi,

I used a VLOOKUP to bring their PO Qty into your sheet based on the ID
Then using conditional formatting, I highlighted the mis-matches in yellow.

Hope this is what you were needing...
See attached.

Compairing Open Orders.xlsx

[benjamin09]

I thought this was it but this is just pulling the first quantity it runs into from that PO and not necessarily the item that it matches up to and quantities.

[AZ-XL]

If the Item and Po together are unique then we can use sumifs
=SUMIFS('Their Open Orders'!A:A,'Their Open Orders'!B:B,A2,'Their Open Orders'!C:C,B2)

[benjamin09]

AZ-XL, how do I get this to show on the tab of 'their open orders'. That's where I need to see if we differ in orders.

[RudiS]

In cell D2 of Their Orders sheet, enter this formula: =SUMIFS('My Open Orders'!F:F,'My Open Orders'!A:A,B2,'My Open Orders'!B:B,C2)
Autofill down...

[RudiS]

In cell D2 of Their Orders sheet, enter this formula: =SUMIFS('My Open Orders'!F:F,'My Open Orders'!A:A,B2,'My Open Orders'!B:B,C2)
Autofill down...