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

22 votes293 views1 answer
Excelvba check for directory
VBA
1 vote222 views1 answer
Vba compile error object required
VBA
0 vote219 views1 answer
Hello world vb.net
VBA
1 vote217 views1 answer
Textbox find and replace vb
VBA
0 vote228 views1 answer
Vba table header name
VBA
0 vote229 views1 answer
Excel vba cell on change
VBA
0 vote222 views1 answer
Excel vba move down to next visible cell
VBA
1 vote207 views1 answer
How to do error handling in access vba
VBA
4 votes265 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote228 views1 answer
Vbnet cycle through charaters in string
VBA