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
Bookmarks