Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixing a vlookup macro that returns #N/A error
I'm running a macro that looks up a value relating to a certain team number
in another worksheet. This other worksheet (vlookup table) is actually a download from another program, and not every team number appears each month as their value may be nil. When this occurs, the vlookup formula gives an #N/A message. How can I make a "0" value appear instead of #N/A?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixing a vlookup macro that returns #N/A error
Wrap your formula in an IF statement.........
=IF(ISNA(YourFormula),0,YourFormula) Vaya con Dios, Chuck, CABGx3 "Grosvenor" wrote: I'm running a macro that looks up a value relating to a certain team number in another worksheet. This other worksheet (vlookup table) is actually a download from another program, and not every team number appears each month as their value may be nil. When this occurs, the vlookup formula gives an #N/A message. How can I make a "0" value appear instead of #N/A?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Visual Basic Error...from MAcro | Excel Discussion (Misc queries) | |||
Macro time out error | Excel Worksheet Functions | |||
Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
Vlookup Syntax Error | New Users to Excel | |||
Vlookup returns incorrect match | Excel Discussion (Misc queries) |