View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sriram N A Sriram N A is offline
external usenet poster
 
Posts: 5
Default Vlookup in user defined function

I think you need ot qualify it fully, as in
test = Application.WorksheetFunction.VLookup(value, table, 2, False)

"Tim Svensson" wrote in message
...
I have a user defined function, but Vlookup doesnt work in
it. This is the part in the function that doesn't work...
any ideas?