Thread: Vlookup Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MJRay MJRay is offline
external usenet poster
 
Posts: 4
Default Vlookup Error

Hello,

I have the following code to perform a lookup:
mtch = Application.WorksheetFunction.VLookup( _
Worksheets("Nabanco").Cells(nr, 14).Value, _
Worksheets("RDMTemp").Range("A1:T5000"), _
20, False)
The error I get is "Run time error 1004, Unable to get the vlookup property
of the WorksheetFUnction class.

Thanks,
Mike