| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup in excel have alternative result than #N/A selectable
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 "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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup in excel have alternative result than #N/A selectable
=IF(ISNA(YourLookupFormula),YourAlternativeResult, YourLookupFormula)
-- Kind regards, Niek Otten "Bruce A" 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 "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "1235" appears as "One thousand two hundred thirty five" | Excel Discussion (Misc queries) | |||
| Currency to Text | Excel Worksheet Functions | |||
| VBA | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
Linear Mode
