Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
#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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
#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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
#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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|