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 vote320 views1 answer
Excel vba arrondir
VBA
0 vote365 views1 answer
Vba get application version
VBA
0 vote362 views1 answer
Excel vba textbox forecolor disabled
VBA
1 vote391 views2 answers
Vba string length
VBA
0 vote372 views2 answers
Get unique random number in vb.net
VBA
0 vote400 views1 answer
Pivot data source not accepting table named range vba
VBA
-1 vote344 views1 answer
For i in range vba
VBA
5 votes373 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote347 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote354 views1 answer
Handling a click event anywhere inside a panel vb
VBA