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 vote194 views1 answer
Excel vba disable alerts
VBA
1 vote195 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote214 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote195 views1 answer
Internet explorer reference vba
VBA
0 vote190 views1 answer
Vba first line of string
VBA
0 vote220 views2 answers
Get unique random number in vb.net
VBA
0 vote145 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote200 views1 answer
Convert unix to date vba
VBA
0 vote197 views1 answer
Vba border weight
VBA
3 votes203 views1 answer
Vba http request json
VBA