jcurran70 said:
I am using the Vlookup function and am trying to figure out a way that a value of zero is displayed instead of #NA when a matching result is not found. Is this possible?
Some options:
1] With Morefunc:
=IF(ISNA(SETV(VLOOKUP(...))),0,GETV())
2] With V(), whose VBA code you can find in one of the threads at this board:
=IF(ISNA(V(VLOOKUP(...))),0,V())
3]
=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...))