Replacing #N/A with a '0' (zero)

[neilcarden]

Hi all,

I'm using a Vlookup to pull figures over from another sheet. Is there a
way that when there isn't any data to pull across, instead of displaying
#N/A it could display a zero?

Thanks in advance...

Neil


--
neilcarden

[Bob Phillips]

=IF(ISNA(lookup_formula),0,lookup_formula)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"neilcarden" <[email protected]> wrote in message
news:[email protected]...
>
> Hi all,
>
> I'm using a Vlookup to pull figures over from another sheet. Is there a
> way that when there isn't any data to pull across, instead of displaying
> #N/A it could display a zero?
>
> Thanks in advance...
>
> Neil
>
>
> --
> neilcarden

[Niek Otten]

=IF(ISNA(YourFormula),0,YourFormula)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"neilcarden" <[email protected]> wrote in message
news:[email protected]...
>
> Hi all,
>
> I'm using a Vlookup to pull figures over from another sheet. Is there a
> way that when there isn't any data to pull across, instead of displaying
> #N/A it could display a zero?
>
> Thanks in advance...
>
> Neil
>
>
> --
> neilcarden

[Vinaya]

IF(ISERROR(VLOOKUP(C1,$A$1:$B$4,2,0)),0,(VLOOKUP(C1,$A$1:$B$4,2,0)))

neilcarden wrote:
> Hi all,
>
> I'm using a Vlookup to pull figures over from another sheet. Is there a
> way that when there isn't any data to pull across, instead of displaying
> #N/A it could display a zero?
>
> Thanks in advance...
>
> Neil
>
>