VLOOKUP - return 0 instead of "#N/A"
=if(iserror(vlookup(...)),0,vlookup(...))
In xl2007:
=iferror(vlookup(...),0)
EDCNB wrote:
When using VLOOKUP to find an exact match for a value, and if there is no
exact match, the formula will return "#N/A". How should I modify the formula
to make it return the number 0 instead?
Thanks
--
Dave Peterson
|