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 vote281 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote283 views1 answer
Vba timestamp -- milliseconds
VBA
3 votes304 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote283 views1 answer
Get current url vb.net
VBA
0 vote335 views1 answer
Winforms dark title bar
VBA
31 votes385 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote297 views1 answer
Vba remove last vbcrlf
VBA
0 vote312 views1 answer
Vba remove the first character of string
VBA
0 vote279 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote269 views1 answer
Quit excel with save changes dialog vb.net
VBA