| 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?? |
| 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) | |||
Threaded Mode
