Forum Discussion
How to return data from another sheet when 2 columns matches
In my spreadsheet, I have 2 sheets. The 3 columns I have in both sheets are PO#, Inv#, and Charges. This is what I want to do. I want the Charges from sheet 2 to automatically load into sheet 1 w...
Assuming you are transferring data from Table2 on Sheet2 to Table1, SUMIFS or XLOOKUP could be used
= SUMIFS(Table2[CHARGES],
Table2[PO],[@PO],
Table2[INV],[@INV])or
= XLOOKUP( 1,
(Table2[PO]=[@PO])*(Table2[INV]=[@INV]),
Table2[CHARGES])