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 vote246 views1 answer
Vba integer to double
VBA
0 vote244 views1 answer
Label de tableau dans des label.text en VBA
VBA
3 votes285 views2 answers
Excel "vba" match last value
VBA
0 vote210 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote234 views1 answer
Vb run command
VBA
0 vote291 views1 answer
Vba is integer
VBA
0 vote238 views1 answer
Vba collection contains
VBA
0 vote228 views1 answer
Excel vba StartUpPosition
VBA
0 vote238 views1 answer
Check if program is running vbnet
VBA
1 vote219 views1 answer
Vba ubound array 2-dimensional
VBA