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 vote265 views1 answer
Make your computer talk vbscript
VBA
0 vote250 views1 answer
Freeze panes vba
VBA
5 votes231 views1 answer
Excel vba how to unit test vba code
VBA
0 vote257 views1 answer
Vba parameter adodb null value
VBA
0 vote237 views1 answer
Vba word open document read only
VBA
1 vote249 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote248 views1 answer
Excel vba calculate
VBA
5 votes269 views1 answer
Excel vba low word from Long Integer
VBA
0 vote248 views1 answer
Excel vba unlock sheet without password
VBA
1 vote219 views1 answer
Excel vba hide zero values
VBA