vlookup, add parameter, on error return user defined value
 

I think certain functions in Excel should be enhanced. Top of mind are
vlookup, hlookup, and getpivotdata. As it is, if I don't want #N/A to
appear, I have to enter my forumla as:
if(isna(formula),0,formula)

This strikes me as ugly and inefficient. Could the formula parameters be
extended to allow the user to define what would be returned on error.
Vlookup would become:
vlookup(value, table, col, true/false, error return value)

I could enter "" (blank), 0, etc as the error return value. If I left it
blank, #N/A would be the default. I suppose the result could even flag the
cell if the error value is returned via the error checking indicator or some
sort of conditional format.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions