VLookup Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA userform Vlookup Excel 1
VLOOKUP & ISNA 2
Vlookup in VBA 4
Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble 8
VLookup error 4
VLookup Function in VB 5
Vlookup Error 3
Vlookup property missing 3

Back
Top