Lookup Error

scott · Dec 31, 2008

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 · Dec 31, 2008

One way:

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

Lookup Error

scott

T. Valko