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 vote148 views1 answer
Vbnet add new ecel sheet
VBA
0 vote168 views1 answer
Send text to clipboard vb.net
VBA
0 vote168 views1 answer
Excel vba urlmon
VBA
2 votes149 views2 answers
Constructor vb.net
VBA
0 vote168 views1 answer
Not allow form to be resized
VBA
1 vote170 views2 answers
Vba string length
VBA
0 vote175 views1 answer
String contins in vba
VBA
6 votes175 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote165 views1 answer
Excel vba hide columns
VBA
0 vote171 views1 answer
Excel vba automatic calculation
VBA