IFERROR for 2003

I always used IF(ISERROR()) method....

There is no IFERROR function equivalent as such. I normally use a MATCH formula in a separate column, then use an INDEX function. For example, in your case I would have:
=MATCH(A2,$AA$1:$AA$99,0)
in a cell (say B2), and then:
=IF(ISNA(B2),”This employee has left the company.”, INDEX($AB$1:$AB$99,B2))
The alternatives are using a combination of LOOKUP and CHOOSE, or writing your own IFERROR function in VBA or in an XLL/DLL for example.

I've been using an IFERROR UserDefinedFunction (UDF) forever now. Install this into your sheet and you can use it the same as in Excel 2007:

Please Login or Register  to view this content.

How to install the User Defined Function:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet

The function is installed and ready to use.
=IFERROR(VLOOKUP(A2, $AA$1:$AB$99, 2, False), "This employee has left the company.")

Hi,

Although it is an old thread I hope it will jump up front.

I tried the proposed UDF and it works fine as long as it is placed in a module inside the active VB.

In a received WB from a 2007 user it shows: _xlfn.IFERROR and the correct result, but when I enter the formula for editing, it gives the #NAME error.

Also, when I put it into my PERSONAL.XLS and/or BOOK.XLT - it returns #NAME?

How can I use this UDF in Excel 2003 when opening an 2007 WB ?

Thanks, Elm

Elm,

Please don't ignore a moderators' request.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.