Lookup Error scott 12/31/2008 4:42:01 PM 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

Re: Lookup Error "T. Valko" <biffinpitt[ at ]comcast.net> 12/31/2008 4:58:05 PM One way: =IF(ISNA(your_formula(...)),0,your_formula(...)) -- Biff Microsoft Excel MVP "scott" <scott[ at ]discussions.microsoft.com> wrote in message news:A90CCC73-A512-4B53-B600-D1319886C08A[ at ]microsoft.com... [Quoted Text] > 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