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 vote274 views1 answer
Vb test if reference is null
VBA
0 vote273 views1 answer
Vbnet add new ecel sheet
VBA
0 vote342 views1 answer
Visual basic cmd
VBA
0 vote301 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote316 views1 answer
Excel vba named range exists
VBA
2 votes321 views2 answers
Excel vba if sunday or staurday
VBA
0 vote303 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote290 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote319 views1 answer
Move bindingnavigator vb
VBA
0 vote293 views1 answer
Limit combobox to list vba
VBA