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 |