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.
Any help is greatly appreciated.{=INDEX(TestDataSet!M:M,MATCH(1,(A2=TestDataSet!A:A)*("RCR"=TestDataSet!J:J),0))}
Kind regards,
Forrestgump1980
Bookmarks