Try

=IF(ISNA(your_formula),"No response",your_formula)

HTH
JG

"jimar" wrote:

I am using vlookup to return data for a particular reference number. If the
reference number is not available I would like to replace the #N/A returns
with the wording "No Response". Is this possible?
Thanks