software

I need to be able to nominate alternative result to #N/A when the vlookup
function fails to find the search criteria in the array being searched.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

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

=IF(ISNA(YourLookupFormula),YourAlternativeResult, YourLookupFormula)

--
Kind regards,

Niek Otten

quot;Bruce Aquot; gt; wrote in message ...
|I need to be able to nominate alternative result to #N/A when the vlookup
| function fails to find the search criteria in the array being searched.
|
| ----------------
| This post is a suggestion for Microsoft, and Microsoft responds to the
| suggestions with the most votes. To vote for this suggestion, click the quot;I
| Agreequot; 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 quot;I Agreequot; in the message pane.
|
|
www.microsoft.com/office/comm...et.f unctions