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 vote59 views1 answer
Vba string
VBA
0 vote50 views1 answer
Excel vba disable copy paste
VBA
0 vote60 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote56 views1 answer
Find days in month vba
VBA
0 vote56 views1 answer
Excel vba unmerge sheet
VBA
0 vote56 views1 answer
Excel vba center userform
VBA
0 vote56 views1 answer
Excel run macro every 5 minutes
VBA
0 vote110 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote56 views1 answer
Vbnet hex to binary
VBA
3 votes56 views1 answer
Vba continue for each loop
VBA