calculate appears even after recalculation

Microsoft Office excel 2003
November 24, 2010 at 20:27:48
Specs: Windows XP professional, CPU T7200@200GHz; 997MHz; 200GB RAM
I am using vlookup and have a number of rows thta have "N/A". I need to delete the "N/A" in these rows. I have been able to do so but as I am nearing the end of my spreadsheet (row 20557) every time I try to delete "N/A" I see "calculate" at the bottom of my spreadsheet even after I press F9. What could be the cause of the problem and how can I solve this. Appreciate your help.

See More: calculate appears even after recalculation

November 24, 2010 at 20:53:38
Deleting #N/A is a waste of time.

It's quicker not to have them appear in the cell in the first place.

This formula will display "" (blank) if the VLOOKUP returns #N/A or the proper value if the VLOOKUP finds what it is looking for.

=IF(ISNA(VLOOKUP(A1, $B$1:$C$100, 2, 0)), "", VLOOKUP(A1, $B$1:$C$100, 2, 0))

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •
Related Solutions

Ask Question