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.

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Natasha" wrote in message
...
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.

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.

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" wrote in message
...
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.

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.

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.

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" wrote in message
...
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" wrote in message
...
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.