IFERROR Makes your life much easier

I had the privilege to do beta testing for Office 2010. Excel is one of the apps I really like so I dove right in to see what could make my life easier in this version. One of the functions surprised me because for years I had been using something similar but 2010 changed all that. I’m talking about the function IFERROR. In earlier functions I would use IF ISERROR and then went on to check the conditions. If you have used this functionality in combination with VLOOKUP you know what I am talking about. A typical check could look something like this:

=IF(ISERROR(VLOOKUP(A1,C13:E25,3,FALSE));”No Match Found”;VLOOKUP(A1,C13:E25,3,FALSE))

or something similar to that.

In 2010 you can now shorten your formula using the IFERROR function. You don’t have to provide an else because Excel understands that it should show the first VLOOKUP result.  Now that’s what I call a real timesaver. Btw if you leave your ‘old’ function the way it is it will work as well.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s