IfError

[Killua Zordic]

I would like to ask alternative ways of doing IFError in Excel 2003? It seems to be too slow as user-defined function like in the example below:

Please Login or Register  to view this content.

IF(Iserror()) formula is not efficient on Index:Match lookups. Thanks in advance!

[royUK]

Welcome to the Forum. Please read the Forum Rules & use Code tags in future.

[Killua Zordic]

Thanks. I edited the post with code tag.

[royUK]

Thanks for the Tags.

[Killua Zordic]

I have a huge excel file with massive error checking on it. I was able to use IFERROR via UDF. Is there any way to speed up the process without running VBA? It is really slow because it calls VBA from my worksheets. Sigh.

[royUK]

How are you using the function? It simply offers a way of marking errors.