Index Match trappping Error Msgs

[billisnice]

What is a decent error trapping message for index match like IFERROR?

[sandy666]

Maybe IFNA()?

[Tony Valko]

Need more specific details of what you're wanting.

[billisnice]

I am looking for an easy way to eliminate #N/A errors. Thanks

[Tony Valko]

The easiest method is to use the IFERROR function. IFERROR will trap ALL errors.

If you only want to trap #N/A errors then there are a couple of options depending on what version of Excel this has to work in.

Your profile says you're using Excel 2013.

It has a new function called IFNA( ). It traps only the #N/A errors.

=IFNA(your formula here,result if #N/A here)

=IFNA(INDEX(A1:A5,MATCH(C1,B1:B5,0)),"")

[billisnice]

Thanks for the help!

[Tony Valko]

You're welcome!

[sandy666]

That is what I said

[sandy666]

Glad to help and thanks for the feedback