Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A instead of 0 when doing a VLOOKUP
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A instead of 0 when doing a VLOOKUP
=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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A instead of 0 when doing a VLOOKUP
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A instead of 0 when doing a VLOOKUP
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A instead of 0 when doing a VLOOKUP
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A instead of 0 when doing a VLOOKUP
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A instead of 0 when doing a VLOOKUP
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |