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 vote241 views2 answers
Excel vba store array and write to sheet
VBA
1 vote185 views1 answer
Excel vba close form escape key
VBA
1 vote178 views1 answer
Vba delete array element
VBA
1 vote174 views1 answer
Excel format cell as kilowatts
VBA
0 vote197 views1 answer
Vba min
VBA
0 vote193 views1 answer
Vb run command
VBA
0 vote202 views1 answer
Vba DisplayGridlines
VBA
0 vote197 views1 answer
Default host vbox address
VBA
0 vote183 views1 answer
How to format a textbox as date vb net
VBA
0 vote186 views1 answer
Excel vba StartUpPosition
VBA