ExcelBanter - VLookup Error

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VLookup Error (https://www.excelbanter.com/excel-programming/370848-vlookup-error.html)

dan

VLookup Error

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

dan

VLookup Error

Sorry - found the function.

On Error Resume Next

"Dan" wrote:

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

All times are GMT +1. The time now is 01:27 PM.