#N/A Help!
 

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!

#N/A Help!
 

Hello
IF(ISNA(VLOOKUP(A5;('ABC'!A1:'ABC'!B2259);2;FALSE) );"Not
Found";VLOOKUP(A5;('ABC'!A1:'ABC'!B2259);2;FALSE))
HTH
Regards
Pascal

"C3" a écrit dans le message de news:
...
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!

#N/A Help!
 

Hi
one way: change your VLOOKUP formula to
=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...))

another way: change your IF clause to
=IF(ISNA(X1),"AAA","BBB")

--
Regards
Frank Kabel
Frankfurt, Germany

"C3" schrieb im Newsbeitrag
...
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!

#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!