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