ISNA
Returns TRUE if the value is the #N/A error value
Syntax
ISNA(value)
Parameters
- value: Required. The value that you want tested
Example
=ISNA(VLOOKUP("x", A:B, 2, FALSE))Returns TRUE if the value is the #N/A error value
ISNA(value)
=ISNA(VLOOKUP("x", A:B, 2, FALSE))