Last Value Lookup in function

[lulupatel]

Dear Sir

I am new in VBA can any one help me to solve my problem, I am getting error for the following Function for last value lookup.

Public Function lastLookup(Value As String, LR As Range, VR As Range)
'LR consider Value contain column and VR consider result Value contain Column

lastLookup = Application.WorksheetFunction.Lookup(2, 1 / (LR = Value), VR)

End Function

if I use same formula in excel sheet I get right answer, but when I use as Function

thanks in advance
lalit patel