I am using a vlookup function and due to data un-availability there is an error (#N/A) shows in a particular cell. I have hidden this error using ISERROR but when I sum these columns the same error (#N/A) appears in Total column.

How can I eliminate this error and get actual values.

Thanks.

Shubhkaran