One way:

Assuming your original formula is something like:

=VLOOKUP(A1,J:K,2,FALSE)

you can trap the error:

=IF(ISNA(MATCH(A1,J:J,FALSE)),"Nothing",VLOOKUP(A1 ,J:K,2,FALSE))

In article ,
BZeyger wrote:

I have numerious calculations occuring in cells. Many times if certain values
cannot be calculted, #N/A appears. I would like the field to display "Null"
or "Nothing" if the error appears. How can this be done? I want a different
display instead of #N/A.