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

=if(iserror(yourformula),0,yourformula)



gb_S49 wrote:

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

--

Dave Peterson

Dave, as always it looks so simple when a expert does it.
Thank you

"Dave Peterson" wrote:

=if(iserror(yourformula),0,yourformula)



gb_S49 wrote:

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

--

Dave Peterson

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

"Dave Peterson" wrote:

=if(iserror(yourformula),0,yourformula)



gb_S49 wrote:

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

--

Dave Peterson

Sussed it wahooooo
was missing second bracket between the first and second formulaes
Thanks

"Dave Peterson" wrote:

=if(iserror(yourformula),0,yourformula)



gb_S49 wrote:

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

--

Dave Peterson

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)


"gb_S49" wrote in message
...
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

"Dave Peterson" wrote:

=if(iserror(yourformula),0,yourformula)



gb_S49 wrote:

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

--

Dave Peterson