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 vote360 views1 answer
Excel vba get column number from column name
VBA
0 vote331 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
0 vote326 views1 answer
Excel vba round to whole number
VBA
1 vote276 views1 answer
Vba exit do while
VBA
0 vote331 views1 answer
Vba add spaces
VBA
0 vote331 views1 answer
Date as number vb
VBA
0 vote303 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote316 views1 answer
Remove series name from legendvbnet
VBA
0 vote319 views1 answer
Xlbycolumns is not declared
VBA
15 votes443 views2 answers
Xl vba dynamic string array
VBA