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 vote114 views1 answer
Excel vba disable screen update
VBA
2 votes118 views1 answer
Excel vba extract file name
VBA
25 votes248 views2 answers
Excel vba folder exist
VBA
0 vote170 views1 answer
Visual basic cmd
VBA
0 vote146 views1 answer
Search for text in every worksheet excel visual basic
VBA
5 votes145 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote119 views1 answer
Excel vba range contains
VBA
0 vote118 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote120 views1 answer
Excel vba chrw max value
VBA
0 vote123 views1 answer
Dynamic array vba
VBA