| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting When #N/A Returned By VLOOKUP
How can I detect when VLOOKUP(_,_,_,FALSE) returns #N/A because there is
not an exact match? If I can detect it I can initiate an alternate calculation. I've tried =IF(VLOOKUP(_,_,_,FALSE)="#N/A", True, False) but no cigar. Any help appreciated. drb |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Detecting When #N/A Returned By VLOOKUP
David
The ISNA() function will trap the error for you: = IF(ISNA(your equation), "whatever", your equation) Steve "David Burkhart" wrote in message ... How can I detect when VLOOKUP(_,_,_,FALSE) returns #N/A because there is not an exact match? If I can detect it I can initiate an alternate calculation. I've tried =IF(VLOOKUP(_,_,_,FALSE)="#N/A", True, False) but no cigar. Any help appreciated. drb |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Detecting When #N/A Returned By VLOOKUP
Steve R wrote:
David The ISNA() function will trap the error for you: = IF(ISNA(your equation), "whatever", your equation) Steve "David Burkhart" wrote in message ... How can I detect when VLOOKUP(_,_,_,FALSE) returns #N/A because there is not an exact match? If I can detect it I can initiate an alternate calculation. I've tried =IF(VLOOKUP(_,_,_,FALSE)="#N/A", True, False) but no cigar. Any help appreciated. drb Works great, thanks for the help. drb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula returned in vlookup function | New Users to Excel | |||
| vlookup returns NA after a second value returned the same | Excel Worksheet Functions | |||
| N/A returned on VLOOKUP formula | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Conditional Sum on VLOOKUP Returned Data | Excel Worksheet Functions | |||
Linear Mode
