Forum Discussion
Adding data ONLY when two cells match across sheets...
Hi all, Apologies: this is complicated... I'm working across x2 sheets in an Excel book. On sheet 2, I have my export page, where I paste the uploaded data for it to fill in sheet 1. On she...
In row 3:
=LET(result, XLOOKUP(A3&B3&C3, 'BO Export'$A$2:$A$1000&'BI Export'!$B$2:$B$1000&'BI Export'!$E$2:$E$1000, 'BI Export'!$C$2:$D$1000, 0), IF(result=0, "", result))
I appreciate this, but unfortunately it is just coming up with a red box and stating that there is an error? I have amended the sheet name to ensure it fully matches, but it's not correcting the error :(
My apologies, my formula contained several typos.
=LET(result, XLOOKUP(A3&B3&C3, 'BI Export'!$A$2:$A$1000&'BI Export'!$B$2:$B$1000&'BI Export'!$E$2:$E$1000, 'BI Export'!$C$2:$D$1000, 0), IF(result=0, "", result))