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 vote147 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote150 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote225 views1 answer
Application.ExecutablePath VB.NET
VBA
1 vote148 views1 answer
Excel vba close form escape key
VBA
2 votes157 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote144 views1 answer
Vba change named range address
VBA
4 votes150 views2 answers
Vba array length
VBA
1 vote142 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote144 views1 answer
Do while not vb.net
VBA
9 votes276 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA