Vlookup vba

Excel vba vlookup

Sub vlookup1()
	Dim student_id As Long
	Dim marks As Long
	student_id = 11004
	Set myrange = Range(“B4:D8”)
	marks = Application.WorksheetFunction.VLookup(student_id, myrange, 3, False)
End Sub

Source: wallstreetmojo.com

Similar codes

0 vote384 views1 answer
Sort dictionary by key vba
VBA
0 vote367 views1 answer
Columns dont autoresize on program start vb.net
VBA
-1 vote410 views1 answer
Vba sendkeys
VBA
1 vote344 views1 answer
Excel vba autofit
VBA
3 votes376 views1 answer
Excel vba get the workbook full filename with path
VBA
1 vote330 views2 answers
Excel vba password protect
VBA
0 vote343 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote286 views1 answer
Vba code to remove leading and trailing spaces
VBA
1 vote355 views1 answer
Excel vba compare 2 rows
VBA
0 vote381 views2 answers
Vb.net include quotes in string
VBA