| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup error | Excel Worksheet Functions | |||
| #N/A Error with VLOOKUP | Excel Worksheet Functions | |||
| #NA error using vlookup in vba | Excel Programming | |||
| #N/A error with VLOOKUP | Excel Discussion (Misc queries) | |||
| using vlookup, but error #N/A | Excel Programming | |||
Linear Mode
