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

4 votes223 views1 answer
Excel formula for last non-empty cell in a column
VBA
5 votes251 views1 answer
Xlvba double quotes in string literal
VBA
0 vote241 views1 answer
Excel run macro every 5 minutes
VBA
9 votes516 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
2 votes220 views2 answers
Constructor vb.net
VBA
7 votes237 views1 answer
Vba array declaration
VBA
0 vote249 views1 answer
Filesystemobject vba reference
VBA
0 vote186 views1 answer
Vbide vbproject reference
VBA
0 vote241 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote221 views1 answer
Style percent not found vba
VBA