| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I replace #n/a in a formula with 0, without erasing my for.
pls. type =if(iserror(vlookup(it's range)),0,vlookup(repeat vlookup formula) "ChiragP" wrote: I have a vlookup formula which sometimes gives the result #n/a ( due to the result not being in the vlookup table ). However, I have another formula which looks at this result and if this result is #n/a then it also gives me the result #n/a. Does anyone know how I can amend this so the second formula recognises the #n/a as a 0 ???? The problem I have is that I need to keep all the formulas |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace with single tick - formula too long.... | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Can you Find and Replace values with in a formula? | Excel Discussion (Misc queries) | |||
| Find and Replace Formula Links | Excel Worksheet Functions | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
Linear Mode
