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

31 votes466 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote335 views1 answer
Vbnet check if string is only numbers
VBA
0 vote334 views1 answer
Vbs send keys
VBA
0 vote390 views1 answer
Filesystemobject vba reference
VBA
2 votes319 views1 answer
Excel vba extract file name
VBA
0 vote333 views2 answers
Excel vba protect cells with formula
VBA
0 vote342 views1 answer
Selecttoken em vbnet e json
VBA
0 vote372 views1 answer
Move bindingnavigator vb
VBA
4 votes315 views1 answer
Excel vba how to reset usedrange
VBA
3 votes343 views1 answer
Vba request json
VBA