Can't seem to use IFERROR with an array formula I have ccreated

[forrestgump1980]

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.

Please Login or Register  to view this content.

Any help is greatly appreciated.

Kind regards,

Forrestgump1980

[JohnTopley]

=IFERROR(INDEX(TestDataSet!M:M,MATCH(1,(A2=TestDataSet!A:A)*("RCR"=TestDataSet!J:J),0)),"")

[Limor_OP]

If you stand on the formula bar you get a syntax helper that can assist you,
If for example you stand after the "index" it opens a statement like that:
=INDEX (array, row_num, [col_num], [area_num])
if you stand on each of the parts it will highlight their place in your formula.

[forrestgump1980]

Hi John, Thanks for your reply, this is what I tried originally and this works with most formulas. However because this is an array formula the syntax is different.

[forrestgump1980]

Hi belinda, Thanks for your reply, I am aware of the formula bar and I use itall the time. However in this example with an array formula it is a little more tricky.

[JohnTopley]

This works with an array formula

[forrestgump1980]

This works with an array formula

Hi John, This does work, apologies

Please Login or Register  to view this content.

I was confused where the outer brackets were.

Thanks

Forrestgump1980