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.