Google Sheets How to get remaining amount when P.O. numbers match

Question

Good Morning all, New to the spreadsheet world and have ran in to a problem. What I'm trying to do is have a formula in the E column of the PO info sheet that will subtract the grand total (O column on invoice submission sheet) from the PO total (C column PO info sheet) when the PO numbers match on both sheets. Appreciate any help

https://docs.google.com/spreadsheets/d/1wsD9xaITn2k-Afp8nhD1kN5UyJ1efRYtYJ87zTFDdsk/edit#gid=0

Answer 1

You can use this formula:

=ifna(C2-vlookup(B2, 'Invoice Submission'!B2:O, 14,0))

Place it in cell E2 of you PO sheet, and drag down. I have placed it in your sheet and it currently works.

---

To subtract the total of each entry:

=ifna(C2-sum(filter('Invoice Submission'!O2:O, 'Invoice Submission'!B2:B=B2)))