=IF(ISNA(VLOOKUP)),"NO RESPONSE",VLOOKUP())

"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