Vertical Lookup is abbreviated as VLOOKUP. It's a function that tells Excel to look for a specific value in a column (the so-called'table array') in order to return a value from another column in the same row.
The following arguments are passed to the VLOOKUP function: Lookup value (mandatory parameter) – The value to search up in the first column of a table is specified by Lookup value. The table array is the data array to be searched (mandatory argument).
Choose a column of cells to populate with new information.
Select 'Function' (Fx) > VLOOKUP from the drop-down menu and paste the formula into the highlighted cell.
Type the lookup value for which you'd like to get fresh information.
Select the table array in the spreadsheet that contains the data you want.
Learner's Ratings
4.7
Overall Rating
84%
9%
5%
2%
0%
Reviews
M
MRIDHA MD MERAJ
5
Very good and Thank you so much
M
Md Mujahidul islam
5
This is a very good course.
M
Md Masud Rana
5
Good job
M
MD Yasin Khan
5
very helpfully for me thanke you learn vern team member
A
Abrar Hossen
5
I am happy for this course ....love you...I want to more course in bangla tutorial...from Bangladesh
Share a personalized message with your friends.