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 vote303 views1 answer
Excel vba round to whole number
VBA
-1 vote303 views2 answers
Excel vba delete empty rows
VBA
0 vote285 views1 answer
Open application from vbnet
VBA
0 vote316 views1 answer
Vba run command
VBA
0 vote281 views1 answer
Vba pass named range to function
VBA
0 vote300 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote337 views1 answer
If statement vdhl
VBA
0 vote297 views1 answer
Excel vba saveas no prompt for overwrite
VBA
3 votes332 views1 answer
Vba continue for each loop
VBA
3 votes334 views1 answer
Vba post request json
VBA