Reconcile two sheets

[Blunder1]

Hi,

I have to reconcile two sheet within a workbook. There is a common reference on most cells, where there isn't the returnng #N/A value tells me this ref is not in the other worksheet and therefore i need to investigate why. Once it finds the ref it then checks two other cells on the same row to ensure the contain the same value, again a returning #N/A value tells me i have to investigate. I have the below formula which compares three cells if the reference matches. The ref in in Column A. So the below array formula works ok but is slow as there are around 8000 rows. Is there a faster way to replace the below using vba?

Thanks in advance

Blunder

{=INDEX(ODS!$A$2:$A$37,MATCH(1,(ODS!$A$2:$A$37=NTPA!A2)*(ODS!$N$2:$N$37=NTPA!M2)*(ODS!$O$2:$O$37=NTPA!N2),0))}

 

[Blunder1]

Ignore this request i have replaced with another one.

Thanks


Blunder