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 vote215 views1 answer
Vb check if row has column
VBA
0 vote230 views1 answer
Vba min
VBA
1 vote227 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote216 views1 answer
Hello world vb.net
VBA
0 vote214 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote209 views1 answer
Excel vba show developer tab
VBA
0 vote220 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote225 views1 answer
Telephon call in vba
VBA
0 vote212 views1 answer
Excel vba milliseconds
VBA
0 vote236 views1 answer
VBA Loop to range
VBA