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 vote271 views1 answer
Excel vba current folder
VBA
5 votes291 views1 answer
Xl vba double quotes in string literal
VBA
0 vote283 views1 answer
Arq linux
VBA
0 vote285 views1 answer
Vba file chooser
VBA
0 vote291 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
1 vote281 views1 answer
Export datagridview to excel vb.net
VBA
15 votes385 views2 answers
Xl vba dynamic string array
VBA
1 vote268 views1 answer
Excel vba get column name from number
VBA
0 vote286 views1 answer
Excel vba remove formatting from cell
VBA
0 vote289 views1 answer
Vbnet cycle through charaters in string
VBA