I have the following formula:
=INDEX(client_CTA_co_organization_regi!$S$2:$S30000,MATCH($B2&$C2,client_CTA_co_organization_regi!$B$2:$B30000&client_CTA_co_organization_regi!$C$2:$C30000,0))
It looks compares an email field between the client_CTA sheet and the email field in column J.
I have...