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

1 vote344 views1 answer
Vba optional
VBA
0 vote350 views1 answer
Loop through lines in text file vb net
VBA
7 votes368 views1 answer
Excerl vba array to range
VBA
0 vote342 views1 answer
Vbnet find highest value in chart
VBA
3 votes349 views1 answer
Excel vba get the workbook full filename with path
VBA
7 votes352 views1 answer
Vba array declaration
VBA
0 vote362 views1 answer
Vba ternary
VBA
1 vote344 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote359 views1 answer
Create links in msgbox in vb
VBA
0 vote354 views1 answer
Excel named range sum
VBA