Hi,
I figured it out:
With Application.WorksheetFunction
If .IsNA(.VLookup(sT, "WasinoParts", 1, True)) = False Then
IsWONPart = True
End If
End With
Thanx,
-plh


On Jul 22, 10:08*am, plh wrote:
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