if iserror

Topic

New Reply

With a normal vlookup I can use if iserror to avoid #N/A:
=IF(ISERROR(VLOOKUP(F2,nvl,2,FALSE)),”Not found”,VLOOKUP(F2,nvl,2))

However, when I try to do a left lookup with index and match:
=INDEX(lreturn,MATCH(F3,lcc,0)) and then add if iserror I get a #Value error.
=IF(ISERROR(INDEX(lreturn,MATCH(F3,lcc,0))),”Not Found”),INDEX(lreturn,MATCH(F3,lcc,0))

What am I doing wrong? I use Excel 2003.
Thanks

itconc

Reply | Quote

Replies

The parentheses aren’t quite correct. Try

=IF(ISERROR(INDEX(lreturn,MATCH(F3,lcc,0))),”Not Found”,INDEX(lreturn,MATCH(F3,lcc,0)))

In fact, you only need to test whether MATCH returns an error:

=IF(ISERROR(MATCH(F3,lcc,0)),”Not Found”,INDEX(lreturn,MATCH(F3,lcc,0)))

Reply | Quote

The parentheses aren’t quite correct. Try

=IF(ISERROR(INDEX(lreturn,MATCH(F3,lcc,0))),”Not Found”,INDEX(lreturn,MATCH(F3,lcc,0)))

In fact, you only need to test whether MATCH returns an error:

=IF(ISERROR(MATCH(F3,lcc,0)),”Not Found”,INDEX(lreturn,MATCH(F3,lcc,0)))

That did it. Thanks, Hans

Reply | Quote