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

3 votes219 views1 answer
Vba continue for each loop
VBA
4 votes207 views2 answers
Excel vba last column with data
VBA
0 vote193 views1 answer
Vbnet line graph smooth lines
VBA
-1 vote194 views1 answer
For i in range vba
VBA
1 vote196 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote219 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote199 views1 answer
Excel text to columns line break
VBA
0 vote211 views1 answer
Excel vba Column Name from Column Number
VBA
1 vote201 views1 answer
Highlight selected cell in excel vba
VBA
0 vote233 views1 answer
Excel vba round to whole number
VBA