Course Content

Course Content


How To Use VLOOKUP in MS Excel

Now we will see one of the special functionality of MS Excel i.e. VLOOKUP.

VLOOKUP means Vertical look up, and HLOOKUP means Horizontal look up.

Suppose we have a table which is vertical in nature, then we can select it and use Transpose option by right clicking to convert it into horizontal table where we will need to use HLOOKUP function, while if it was kept vertical than VLOOKUP.

Using vlookup we can compare any two tables with each other.

This function compares the value of any one column from both tables to each other and then give the required value in the particular cell.

Now to apply this function we will write it as a normal formula that is '=vlookup(A1,L3:M3,2' where A1 is the value which we need to compare, L3:M3 is the table with which we need to compare A1, and we have written 2 at last because that column's value we need to print from the table.

Now to apply this formula for whole column we can use our absolute value function by pressing F4 key, and then drag it according to our requirement.

So this is how VLOOKUP function works, and whenever we use this function we need to take care of one thing that is the table should be in ascending order.


The VLOOKUP function in Excel is a powerful tool that allows you to find data in a spreadsheet, for example, to find the total sales for January across the range of months. It's also used in formulas that compute totals, averages, or percentages or return text values.VLOOKUP is a simple function in Excel that lets you find information from one table in another. The function looks up a value from the top row of an array and returns the corresponding value from a range of cells in a table. VLOOKUP in Excel is a VLOOKUP function that makes finding data easier and faster than ever. This easy-to-use function is one of the most popular and widely used functions in Excel.

VLOOKUP stands for 'Vertical Lookup'.VLOOKUP function is the most common lookup formula in Excel. It searches a table for a value and returns a corresponding cell. Vlookup Function: Vlookup function accepts two inputs: The lookup value and the range of cells to search.. Vlookup function uses to index and match criteria to find the corresponding value within a range.

Vlookup is a simple & easy use data lookup tool for Excel. There are a lot of uses for it - from organizing a spreadsheet to generating formulas and building pivot tables. There are many ways in which you can use Vlookup in Excel. For instance, you can use it to find the value of a person's name from their Social Security number, or find the values of various product categories from their prices. Vlookup is a very useful function in Excel. It can search a set of data and return a value from one cell to another. Vlookup is usually used with the intersect feature, which shows the intersection of two data ranges.

Recommended Courses

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
App Store
397K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
13K+ 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