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 vote173 views1 answer
Excel vba get column number from column name
VBA
0 vote172 views1 answer
Excel vba StartUpPosition
VBA
0 vote169 views1 answer
Vba run command
VBA
1 vote165 views1 answer
Excel vba compare 2 rows
VBA
0 vote179 views1 answer
Default host vbox address
VBA
0 vote176 views1 answer
Vba sort multiple columns
VBA
1 vote192 views1 answer
Perform http request in vb.net
VBA
3 votes173 views1 answer
Vba request json
VBA
1 vote183 views1 answer
Find and replace textbox
VBA
4 votes163 views1 answer
Excel vba check cell not empty
VBA