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.
Share With Friend
Have a friend to whom you would want to share this course?
Download LearnVern App
Code Scan
or
Download the app
598K+
Downloads
4.57
Avg. Ratings
15K+
Reviews
Learn anywhere on the go
Get regular updates about your enrolled or new courses
Share content with your friends
Evaluate your progress through practice tests
No internet connection needed
Enroll for the webinar and join at the time of the webinar from anywhere
Enjoying this course!
All the Courses on Learnvern are Free! So Register/Sign in to
have Access all the Courses and Videos.