G Guest Apr 25, 2005 #1 is there a way that instead of the following =VLOOKUP($AD$3,Jan,$AD4,0) reporting back #N/A to report back for example 0
is there a way that instead of the following =VLOOKUP($AD$3,Jan,$AD4,0) reporting back #N/A to report back for example 0
D Dave Peterson Apr 25, 2005 #2 =if(iserror(yourformula),0,yourformula) gb_S49 said: is there a way that instead of the following =VLOOKUP($AD$3,Jan,$AD4,0) reporting back #N/A to report back for example 0 Click to expand...
=if(iserror(yourformula),0,yourformula) gb_S49 said: is there a way that instead of the following =VLOOKUP($AD$3,Jan,$AD4,0) reporting back #N/A to report back for example 0 Click to expand...
G Guest Apr 25, 2005 #4 sadly it did not work..it seems that it does not like the ,0, I have tried to encapuslate it in speach marks but that did not work either
sadly it did not work..it seems that it does not like the ,0, I have tried to encapuslate it in speach marks but that did not work either
G Guest Apr 25, 2005 #5 Sussed it wahooooo was missing second bracket between the first and second formulaes Thanks
B Bob Phillips Apr 25, 2005 #6 Specifically for #N/A =IF(ISNA(VLOOKUP($AD$3,Jan,$AD4,0)),0,VLOOKUP($AD$3,Jan,$AD4,0)) -- HTH RP (remove nothere from the email address if mailing direct)
Specifically for #N/A =IF(ISNA(VLOOKUP($AD$3,Jan,$AD4,0)),0,VLOOKUP($AD$3,Jan,$AD4,0)) -- HTH RP (remove nothere from the email address if mailing direct)
