Hi,

I have a big excel file that uses a lot for Vlookup formulas. SOem fo these are returning #N/A.

Now my problem is i have to use the output results populated in these cells for some other formulas and charts and hence i want to replace the existing #N/A 's with blanks.

I can't rebuld the excel with IF (ISNUMBER(), Vlookup, "") method. And if i try to use Control + Replace it doesnt looks for the cell value rather it looks for the formula and hence doesnt finds #N/A's.

If somebody has any idea on this then you help would be highly appreciated.

Cheers,
Gaurav