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

8 votes434 views1 answer
Vba make a short integer from two bytes
VBA
0 vote346 views2 answers
Excel vba number format file size
VBA
1 vote373 views1 answer
Perform http request in vb.net
VBA
0 vote342 views1 answer
Excel named range sum
VBA
1 vote306 views2 answers
Vba remove first 2 characters from string
VBA
0 vote293 views1 answer
Excel vba milliseconds
VBA
1 vote379 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote323 views1 answer
Vba collection key list
VBA
0 vote307 views1 answer
Excel vba extract year
VBA
0 vote296 views1 answer
Excel vba assign shortcut key to button
VBA