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

1 vote269 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote292 views1 answer
Vba search string position
VBA
-1 vote262 views1 answer
For i in range vba
VBA
0 vote273 views1 answer
How to use if condition in time vba
VBA
0 vote286 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
1 vote265 views1 answer
If inputbox cancel vba
VBA
0 vote278 views1 answer
Vba change named range address
VBA
1 vote272 views2 answers
Vba function return array
VBA
1 vote262 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote273 views1 answer
Excel run macro every 5 minutes
VBA