Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing a #na
I have a vlookup and when there is nothing for it to lookup as of yet, I get
a #Na, is there an =if iserror fomula I can add to the vlookup that will let me add a "0" instead of the #na? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing a #na
You can do something along these lines:
=IF(ISERROR(VLOOKUP(A1,$K1:$L21,2),0,VLOOKUP(A1,$K 1:$L21,2)) If would prefer nothing replace the 0 with "", or "Your Message Goes Here". -- Kevin Backmann "Pammy" wrote: I have a vlookup and when there is nothing for it to lookup as of yet, I get a #Na, is there an =if iserror fomula I can add to the vlookup that will let me add a "0" instead of the #na? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing a #na
Use ISNA
=IF(ISNA(your_formula),0,your_formula) it's generally better to use ISNA in a case like this since one might want to know if there are other errors involved and ISNA only finds #N/A errors -- Regards, Peo Sjoblom "Pammy" wrote in message ... I have a vlookup and when there is nothing for it to lookup as of yet, I get a #Na, is there an =if iserror fomula I can add to the vlookup that will let me add a "0" instead of the #na? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing ? | Excel Worksheet Functions | |||
Replacing #N/A | Excel Worksheet Functions | |||
Replacing #N/A with a '0' (zero) | Excel Worksheet Functions | |||
replacing #N/A with 0 | Excel Discussion (Misc queries) | |||
Help Replacing all ( * ) with ( - ) | Excel Discussion (Misc queries) |