Hi All,

I have the following array formula which works but I want to also use an IFERROR to return "" (i.e. BLANK) if there is an error. Im not sure what the correct syntax would be.

{=INDEX(TestDataSet!M:M,MATCH(1,(A2=TestDataSet!A:A)*("RCR"=TestDataSet!J:J),0))}
Any help is greatly appreciated.

Kind regards,

Forrestgump1980