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...
I understand why you want to match Beh colum B with A2 and Beh column A with B2, but why do you also match on column C? Wouldn't it be better to use
=IF(COUNTIFS(Beh!B:B, A2, Beh!A:A, B2), "Yes", "No")