Lookup Error

[scott]

In my ss I am using Lookup. It is doing just want I want it to do except in
some cells I am getting a #N/A erro. Is there away to show this error as a
zero. Thanks

 

[T. Valko]

One way:

=IF(ISNA(your_formula(...)),0,your_formula(...))