Oct 29 2020 12:51 PM
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 when PO# and Inv# matches in both sheets.
Oct 29 2020 01:30 PM
@ybotL try
=SUMPRODUCT('SHEET2'!C:C*(A2='SHEET2'!A:A)*(B2='SHEET2'!B:B))
Oct 30 2020 01:34 AM
You need an array (CSE) formula, fixes the issue:
{=IFERROR(INDEX(Sheet2!$C$33:$C$39,MATCH(Sheet1!A25&Sheet1!B25,Sheet2!$A$33:$A$39&Sheet2!$B$33:$B$39,0)),"")}
N.B.
**** If you find this works for you then you may marks it as Best Answer as well as Like.
Oct 30 2020 03:04 AM
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])