How do I replace a return value of #N/A in a vlookup with zero?
Rather than #N/A being returned from a lookup for a value that is not in the
lookup table can I replace the returned #N/A with a zero?
Without being able to do this I am unable sum the returned values.
|