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 vote224 views1 answer
Vba sheet hide unhide
VBA
0 vote213 views1 answer
Get current year vb
VBA
0 vote219 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote232 views1 answer
Vbscript remove spaces from string
VBA
1 vote207 views1 answer
Excel vba saveas force overwrite
VBA
1 vote192 views1 answer
How to do error handling in access vba
VBA
0 vote211 views1 answer
Vb net dgv doesn't keep currency format
VBA
31 votes276 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote246 views1 answer
Filesystemobject vba reference
VBA
3 votes221 views1 answer
Excel vba change format of cell
VBA