Course Content

Course Content


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

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • 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