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 vote255 views1 answer
Vba open report
VBA
0 vote231 views1 answer
Change "location" of binding navigator vb
VBA
1 vote244 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote252 views1 answer
Vba keep command window open
VBA
1 vote234 views1 answer
Excel vba get ordinal number from cardinal number
VBA
8 votes247 views1 answer
Excel vba make integer
VBA
0 vote250 views3 answers
Write to text file vb.net
VBA
0 vote239 views1 answer
Excel VBA web scraping
VBA
3 votes242 views2 answers
Vba active workbook path
VBA
1 vote240 views1 answer
Excel vba array remove first
VBA