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.6
Overall Rating
81%
11%
5%
3%
0%
Reviews
S
Srijib Bhadra
5
MS Excel is a very important course, and it has helped me a lot in many ways
S
Sakibul Hasan Akash
5
"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
Share a personalized message with your friends.