Dear Sir,

When VLOOKUP formula fails to find the perfect match it always return with
#N/A.

Usually #N/A disable me to do any computation that involve that cell. The
result of any additional function always return with #N/A as well.

To overcome this problem. I always convert the formulas to values, sort it
out and clear those #N/A cells and enter zero to them.

Just take an example of the formula = VLOOKUP(B2, K24: Q120, 6,FALSE), may
In know if I could manipulate the formula to enable it to show 0.00 instead
of #N/A when match could not be found ?


Thanks

Low

A36B58K641