Hi Sunil,
Here's an example:
Private Sub CommandButton1_Click()
Set myRng = Worksheets("Sheet1").Range("A1:B10")
myLookup = 4
myValue = WorksheetFunction.VLookup(myLookup, myRng, 2)
End Sub
The table is A1:B10.
myLookup is the lookup_value which would be in column A. myValue is the
value corresponding to the myLookup as returned by the above formula.
2 is the column index number which tells the lookup to look for the
result in the second column of the table A1:B10 i.e. column B
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=378023