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 vote299 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote301 views1 answer
Vbscript check if string contains
VBA
3 votes316 views1 answer
Vba http request json
VBA
6 votes343 views1 answer
Excel vba check if a string only contains letters
VBA
3 votes310 views1 answer
Excel vba get the workbook full file name with path
VBA
1 vote292 views1 answer
Close form vba
VBA
1 vote304 views1 answer
Sort using vba
VBA
0 vote302 views1 answer
Excel vba show developer tab
VBA
0 vote296 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote314 views2 answers
Delete all controls from list of control vb.net
VBA