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 vote149 views1 answer
Return na vba
VBA
1 vote138 views1 answer
Random number generator vb.net
VBA
1 vote133 views1 answer
Excel vba make cell visible
VBA
1 vote134 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote124 views1 answer
Vbnet display all axis labels in cahrt
VBA
3 votes134 views1 answer
Excel vba read registry key value
VBA
0 vote132 views1 answer
Change whcih control a user has selected vb
VBA
0 vote139 views1 answer
Vba boolean to string
VBA
0 vote137 views1 answer
Check range is in another range vba
VBA
0 vote175 views1 answer
Set datetimepicker value to null vb
VBA