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 vote326 views1 answer
Vbscript convert ascii code to character
VBA
4 votes348 views1 answer
Vba create directory
VBA
0 vote329 views1 answer
Vbnet check if string is only symbols
VBA
1 vote337 views1 answer
Vba refresh pivot table
VBA
0 vote349 views1 answer
Vba range clear formatting
VBA
0 vote348 views1 answer
Vba createparameter null
VBA
0 vote367 views1 answer
Windows Forms dark title bar
VBA
0 vote348 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote338 views1 answer
How to get value from clipboard in vbnet
VBA
-1 vote329 views1 answer
Text to speech vb.net
VBA