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 vote111 views1 answer
Open application from vbnet
VBA
0 vote132 views1 answer
Sort dictionary by key vba
VBA
0 vote145 views1 answer
How to enter Vbox manage commands
VBA
0 vote127 views1 answer
Vbscript remove spaces from string
VBA
0 vote112 views1 answer
Find the name of the last excel sheet vb
VBA
4 votes137 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote153 views1 answer
Windows Forms dark title bar
VBA
0 vote123 views1 answer
Excel vba protect worksheet without password
VBA
0 vote116 views1 answer
Excel last used row
VBA
1 vote120 views1 answer
Vba optional
VBA