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 vote275 views1 answer
Vba full date format
VBA
3 votes280 views2 answers
Excel "vba" match last value
VBA
0 vote268 views1 answer
Hello world vb.net
VBA
6 votes312 views1 answer
Excel vba check if a string only contains letters
VBA
1 vote292 views1 answer
Vba loop through files in folder
VBA
0 vote297 views3 answers
Write to text file vb.net
VBA
0 vote271 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote280 views1 answer
Vbscript check if string is empty
VBA
0 vote282 views1 answer
Excel vba hide gridlines
VBA
0 vote288 views1 answer
Vba collection contains
VBA