Vlookup in user defined function
 

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

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?