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

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