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

1 vote120 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote122 views1 answer
Vba border weight
VBA
0 vote126 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote119 views1 answer
Excel vba center userform
VBA
0 vote124 views1 answer
Vba get relative cell address
VBA
0 vote123 views1 answer
Vba option button selected
VBA
4 votes123 views2 answers
Vba array length
VBA
0 vote121 views1 answer
Excel vba join variant array
VBA
8 votes147 views1 answer
Run command pormpt in background windows
VBA
0 vote142 views1 answer
Vbscript check if string contains
VBA