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 vote157 views1 answer
Create new worksheet excel visual basic
VBA
1 vote180 views1 answer
Vb.net get name by Cell Click
VBA
0 vote182 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote172 views1 answer
Visual stuiod not recognising desgined labels
VBA
1 vote168 views1 answer
Highlight selected cell in excel vba
VBA
1 vote160 views2 answers
Excel vba password protect
VBA
0 vote156 views1 answer
Excel vba populate array with cell values
VBA
1 vote171 views2 answers
Vba remove first 2 characters from string
VBA
1 vote171 views1 answer
Vba reverse string
VBA
12 votes224 views1 answer
Excel vba write string to text file
VBA