Vlookup in user defined function

  • Thread starter Thread starter Tim Svensson
  • Start date Start date
T

Tim Svensson

I have a user defined function, but Vlookup doesnt work in
it. This i the part in the function that doesn't work...
any ideas?

thanks

/Tim


Function test(value, table)

test = VLookup(value, table, 2, False)

End Function
 
I think you need ot qualify it fully, as in
test = Application.WorksheetFunction.VLookup(value, table, 2, False)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested If Function to be converted into a user-defined customfunction 1
Vlookup Function 1
VLookup error - Sub or function not defined 4
Runtime error 1004 when trying to insert formula in cells 11
Vlookup Error 0
VBA userform Vlookup Excel 1
Vlookup result in a message box 10
User Defined Function 5

Back
Top