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??
Bookmarks