VLOOKUP, Excel Formula stands for ‘Vertical Lookup’.
Without writing long paragraph on Vlookup and its formula, refer to below picture:
In this example, I am looking for Grade of each students.
On left Table I have Student Name and Roll No. and on Right I have Roll No and Grade.
I want to get Grade of each student from 2nd excel table.
So using vlookup I can get it. For both table I have a common column i.e Roll No.
=VLOOKUP(C3,’Student Grade’!B$3:C$5,2,0)
Here 0 is for Flase (Exact Match), and 1 is for True(Approximate Match).