#N/A Help!
YOu need to use "ISERROR". look for it in help for more info. Here is
a small example.
=IF(ISERROR(VLOOKUP(C1,D1:E13,2,FALSE)),"",VLOOKUP (C1,D1:E13,2,FALSE))
good luck,
Cesar Zapata
C3 wrote:
Example:
Cell X contains formula VLOOKUP(A5;('ABC'!A1:'ABC'!B2259);2;FALSE) and
result of it is #N/A (Did not find anything). How to phrase IF formula (etc.
IF(X=0;"AAA";"BBB") where 0 is #N/A). When I write (0 for #N/A) - IF(X=0...
return is #N/A.
Help!
|