Prev: Scroll bar disappears when panes frozen
Next: Highlight Five Values With Conditional Formula
From: Emece on 30 Mar 2010 12:09
When I use the vLookup formula and the result is #N/A, I need to replace this
with a 0, is this possible in only one formula?

Thanks in advance

Regards
Emece.-
From: Gary''s Student on 30 Mar 2010 12:13
Something like:

=IF(ISNA(VLOOKUP(A1,B1:B2,2)),0,VLOOKUP(A1,B1:B2,2))

--
Gary''s Student - gsnu201001


"Emece" wrote:

> When I use the vLookup formula and the result is #N/A, I need to replace this
> with a 0, is this possible in only one formula?
>
> Thanks in advance
>
> Regards
> Emece.-
 | 
Pages: 1
Prev: Scroll bar disappears when panes frozen
Next: Highlight Five Values With Conditional Formula