Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup in VB not returning anything error
Hi, I am trying to get the following working:
If Application.WorksheetFunction.IsNA(Application. _ WorksheetFunction.VLookup(lookUpValue, myRange, 1, False)) = False Then I have tested it where it should not be able to find anything from the vlookup and it causes an error of 1004 unable to get the vlookup property of the worksheet class. How would I go about getting this to work? Thanks, Grant. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula returning an error | Excel Worksheet Functions | |||
VLOOKUP returning a #VALUE! error and I've not idea why! HELP!!! | Excel Worksheet Functions | |||
Vlookup Function returning #N/A error for two entries | Excel Discussion (Misc queries) | |||
Formula returning #N/A Error---why??? | Excel Worksheet Functions | |||
Returning Error from Functions | Excel Programming |