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...
Aha!! HansVogelaar​ - I hadn't noticed that!! So that's a semi-solution and I'm very grateful!!
Column C needed to match Cell E2 as we have students with identical names but in different year groups! I'm now getting the 'Yes' that I needed!!
Do you happen to have any idea how to complete the other part? I need Sheet 2 Export columns C and D to fill Sheet 1 Overview columns H and I?
The original formula that I need to amend-to-fit is:
=IF(XLOOKUP($A706,'BI export'!$A:$A,'BI export'!B:B,"",0)=0,"",XLOOKUP($A706,'BI export'!$A:$A,'BI export'!B:B,"",0))