#N/A instead of 0 when doing a VLOOKUP

[Natasha]

I am using a VLOOKUP and everything is fine except when the result is 0, it
gives a #N/A instead of a 0. How do I get rid of the #N/A when doing a , I
want want the result to be 0.

[Bob Phillips]

=IF(ISNA(vlookup_formula),0,vlookup_formula)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Natasha" <[email protected]> wrote in message
news:[email protected]...
> I am using a VLOOKUP and everything is fine except when the result is 0,
it
> gives a #N/A instead of a 0. How do I get rid of the #N/A when doing a , I
> want want the result to be 0.

[Pendelfin]

Please can you copy and paste the formula you have entered, and I may be able
to tell you where you went wrong.

"Natasha" wrote:

> I am using a VLOOKUP and everything is fine except when the result is 0, it
> gives a #N/A instead of a 0. How do I get rid of the #N/A when doing a , I
> want want the result to be 0.

[Natasha]

Thank you your formula works, it is just very long.
Is there not a setting I can change on my PC? as my collegues laptop gives a
0 and not the #N/A result automatically when using the normal formual e.g.:
=VLOOKUP(A56,Per3!$A$1:$D$109,4,FALSE)

Thanks
Natasha

"Bob Phillips" wrote:

> =IF(ISNA(vlookup_formula),0,vlookup_formula)
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "Natasha" <[email protected]> wrote in message
> news:[email protected]...
> > I am using a VLOOKUP and everything is fine except when the result is 0,
> it
> > gives a #N/A instead of a 0. How do I get rid of the #N/A when doing a , I
> > want want the result to be 0.
>
>
>

[Natasha]

Hi, thanks for your response.
The formula works, it is: =VLOOKUP(A56,Per3!$A$1:$D$109,4,FALSE)
My problem must be a setting somewhere. When there is a line where no info
or result are, it gives me a #N/A instead of a 0. My colleges Laptop
automatically gives a 0 and I do not know why.
Thanks
Natasha


"Pendelfin" wrote:

> Please can you copy and paste the formula you have entered, and I may be able
> to tell you where you went wrong.
>
> "Natasha" wrote:
>
> > I am using a VLOOKUP and everything is fine except when the result is 0, it
> > gives a #N/A instead of a 0. How do I get rid of the #N/A when doing a , I
> > want want the result to be 0.

[Pendelfin]

The only way I would write it would be.

=IF(ISERROR(VLOOKUP(A56,Per3!$A$1:$D$109,4,FALSE)),0,VLOOKUP(A56,Per3!$A$1:$D$109,4,FALSE))

Hope this helps.

"Natasha" wrote:

> Hi, thanks for your response.
> The formula works, it is: =VLOOKUP(A56,Per3!$A$1:$D$109,4,FALSE)
> My problem must be a setting somewhere. When there is a line where no info
> or result are, it gives me a #N/A instead of a 0. My colleges Laptop
> automatically gives a 0 and I do not know why.
> Thanks
> Natasha
>
>
> "Pendelfin" wrote:
>
> > Please can you copy and paste the formula you have entered, and I may be able
> > to tell you where you went wrong.
> >
> > "Natasha" wrote:
> >
> > > I am using a VLOOKUP and everything is fine except when the result is 0, it
> > > gives a #N/A instead of a 0. How do I get rid of the #N/A when doing a , I
> > > want want the result to be 0.

[Bob Phillips]

Fraid not. You could use conditional formatting to hide #N/A but I would
advise against it, I don't beleiev in hiding errors, better to deal with
them.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Natasha" <[email protected]> wrote in message
news:[email protected]...
> Thank you your formula works, it is just very long.
> Is there not a setting I can change on my PC? as my collegues laptop gives
a
> 0 and not the #N/A result automatically when using the normal formual
e.g.:
> =VLOOKUP(A56,Per3!$A$1:$D$109,4,FALSE)
>
> Thanks
> Natasha
>
> "Bob Phillips" wrote:
>
> > =IF(ISNA(vlookup_formula),0,vlookup_formula)
> >
> > --
> >
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from the email address if mailing direct)
> >
> > "Natasha" <[email protected]> wrote in message
> > news:[email protected]...
> > > I am using a VLOOKUP and everything is fine except when the result is
0,
> > it
> > > gives a #N/A instead of a 0. How do I get rid of the #N/A when doing a
, I
> > > want want the result to be 0.
> >
> >
> >