result returns #N/B
Does Excel calculate VLOOKUP twice in that example?
"Dave Peterson" wrote in message
...
in English, I'd use:
=if(iserror(vlookup(...)),0,vlookup(...))
Léon wrote:
When i use a formula like " VLOOKUP ", sometimes the result is #N/B. Is
it
possible to change the result in 0 (zero)? It would help me to use it in
calculations. E.g. when i use SUM and one of the results is #N/B, the
result
of the SUM is #N/B.
--
Dave Peterson
|