The fix is to correct the formulas that produce #N/A - in a
well-designed worksheet, you shouldn't get errors for expected results.

For instance, if your formula is a VLOOKUP like

=VLOOKUP(A1234, Sheet2!A:B, 2, FALSE)

then you could use

=IF(ISBLANK(A1234), "", VLOOKUP(A1234,Sheet2!A:B, 2, FALSE))



In article ,
"Judy" wrote:

I don't suppose there's a fix for that!