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 vote154 views1 answer
Vba sheet visible
VBA
0 vote152 views1 answer
Vba get relative cell address
VBA
0 vote165 views1 answer
VBA
VBA
1 vote152 views2 answers
Vba string to date
VBA
0 vote165 views1 answer
VBA Sort RossetaCode
VBA
0 vote203 views1 answer
Excel vba protect content
VBA
0 vote191 views1 answer
Vbnet check if string is only letters
VBA
0 vote174 views1 answer
Vba round to 2 decimals
VBA
0 vote147 views1 answer
Do until vb.net
VBA
4 votes108 views2 answers
Vba last row
VBA