G
gb_S49
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
reporting back #N/A to report back for example 0
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
=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
G
gb_S49
Dave, as always it looks so simple when a expert does it.
Thank you
Thank you
G
gb_S49
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
encapuslate it in speach marks but that did not work either
G
gb_S49
Sussed it wahooooo
was missing second bracket between the first and second formulaes
Thanks
was missing second bracket between the first and second formulaes
Thanks
B
Bob Phillips
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)
=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)