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 vote158 views1 answer
.net dark title bar
VBA
0 vote137 views1 answer
Vbnet add new ecel sheet
VBA
0 vote166 views1 answer
Vba clear collection
VBA
1 vote163 views1 answer
Vba format string as cash
VBA
1 vote147 views1 answer
Close form vba
VBA
3 votes159 views1 answer
Vba http request json
VBA
-1 vote150 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote155 views1 answer
Vba type
VBA
1 vote156 views1 answer
Vbscript convert ascii code to character
VBA
0 vote146 views1 answer
Vbnet line graph smooth lines
VBA