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)
 
Back
Top