Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Everyone,
MS Excel 2003 SP3: VLookup is on the list of functions available listed by Help, but the folowing code generates the error "Sub or Function not defined". If IsNA(VLookup(sT, "WasinoParts", 1, True)) = False Then IsWONPart = True End If The blue light is on "VLookup". Seems it is OK with IsNA. I am thinking I need to load a reference library but can anyone tell me which one? The list is long and bewildering. The ones I have loaded are as follows: Visual Basic for Applications Microsoft Excel 11.0 Object Library OLE Automation Microsoft Office 11.0 Object Library Your help would be very much appreciated! Thank You, -plh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trouble with Vlookup | Excel Discussion (Misc queries) | |||
VLOOKUP Trouble | Excel Programming | |||
Trouble with vLookup | New Users to Excel | |||
VLOOKUP trouble .. HELP! | Excel Worksheet Functions | |||
VLookup with VBA trouble :-( | Excel Programming |