change your formula as..

=IF(ISERROR(VLOOKUP(B2, K24: Q120, 6,FALSE)),0,VLOOKUP(B2, K24: Q120,
6,FALSE))

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Mr. Low" wrote:

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