In running VLookup, based on some values, I receive the Run-time error
'1004': Unable to get the VLookup property of the WorkSheetFunction class.

Is there a way that when this error occurs use it to generate a response
"Data Not Available" to be inserted into the desired field?

Thanks