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 vote227 views1 answer
Vbs expand env var
VBA
0 vote179 views1 answer
Vba set vs dim
VBA
-1 vote236 views1 answer
Code for reading letters only in vb 6
VBA
0 vote215 views1 answer
Vbscript abs
VBA
1 vote214 views1 answer
Close form vba
VBA
0 vote218 views1 answer
Vba loop through table
VBA
1 vote221 views1 answer
Vba refresh pivot table
VBA
0 vote221 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote235 views1 answer
Vbs run with cscript
VBA
0 vote230 views1 answer
Vb.net change cursor to wait
VBA