#N/A instead of 0 when doing a VLOOKUP

N

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.
 
B

Bob Phillips

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

--

HTH

Bob Phillips

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

Pendelfin

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

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
 
N

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
 
P

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.
 
B

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)
 
Top