Forum Discussion
Re: Adding data ONLY when two cells match across sheets...
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 :(
1 Reply
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))
