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 vote196 views1 answer
Vbnet check if string is only numbers
VBA
6 votes174 views1 answer
Excel vba get the path of current workbook
VBA
-1 vote154 views1 answer
For i in range vba
VBA
0 vote163 views1 answer
Send text to clipboard vb.net
VBA
1 vote170 views1 answer
Add rows to datagridview vb.net
VBA
0 vote164 views1 answer
Average vba
VBA
0 vote173 views1 answer
How to get value from clipboard in vbnet
VBA
1 vote159 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote159 views1 answer
Remove last 8 characters from string vb
VBA
0 vote151 views1 answer
Find days in month vba
VBA