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 vote227 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote213 views1 answer
Vba open report
VBA
3 votes219 views1 answer
Vba double quote
VBA
3 votes228 views1 answer
Vba continue for each loop
VBA
0 vote221 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote210 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote232 views1 answer
For each item in folder outlook vba
VBA
0 vote264 views2 answers
Excel vba store array and write to sheet
VBA
0 vote208 views3 answers
Write to text file vb.net
VBA
0 vote213 views1 answer
Vba remove last vbcrlf
VBA