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 vote162 views2 answers
Excel vba prevent save
VBA
1 vote172 views1 answer
Vba refresh pivot table
VBA
0 vote184 views2 answers
Excel vba number format file size
VBA
0 vote180 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
4 votes191 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote175 views1 answer
Vba pass named range to function
VBA
3 votes182 views1 answer
Excel vba change format of cell
VBA
0 vote181 views1 answer
Weekday vba
VBA
0 vote164 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote183 views1 answer
Check if program is running vbnet
VBA