Vlookup question

[jcurran70]

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?

 

[Aladin Akyurek]

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(...))