From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

VLOOKUP function MS Excel


The Vlookup function MS Excel is a tool that allows users to quickly search for and retrieve information stored in a spreadsheet. It is particularly useful for quickly finding values in large datasets where manual searches would be too time-consuming.

Vlookup stands forvertical lookup“. It allows users to search for a specific value in the leftmost column of a table and retrieve a value from the same row in a different column. This is useful in many situations, such as when you need to find a customer‘s order number based on their name or a product‘s price based on its ID.

Using the Vlookup function is simple. First, the user must select the range of cells that contains the data they want to search. Then, they enter the value they are searching for in the first argument of the function. The second argument specifies which column of the data range contains the value they are looking for. The third argument is optional and allows the user to specify what kind of search to perform. Finally, the last argument is the cell that will contain the resulting value.

A Vlookup function is an invaluable tool for quickly finding information stored in a large Excel spreadsheet. It can save users a lot of time and effort when compared to manual searches. It is also useful for quickly retrieving values from different columns in the same row, enabling users to quickly perform calculations or generate reports.


=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

lookup_value The value to search for in the leftmost column of the table array.

table_array The table array that contains the data to be searched.

col_index_num The column number in the table array from which the matching value must be returned.

[range_lookup] A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match:

  • TRUE for an approximate match
  • FALSE for an exact match.
  • The default value is TRUE.
VLOOKUP Function MS Excel - Ajelix Excel Formula Cheat Sheet

How to use VLOOKUP function in your workbook:

  1. Open your Excel file and select the cell that you want to display the result of the Vlookup.
  2. Type in the formula =VLOOKUP(.
  3. Enter the value that you want to search for. This is often referred to as the lookup value.
  4. Enter the range of cells that you want to search in. This range needs to include the column that contains the value you want to return.
  5. Enter the column number of the value that you want to return.
  6. Enter either TRUE or FALSE to indicate whether or not an exact match is required.
  7. Press enter to complete the formula.
  8. The result of the Vlookup will appear in the cell you selected.

Struggling with your Excel formulas?

Try out for free AI Excel Assistant who can generate Excel and Google Sheets formulas from your text. Explain your formulas and give descriptions to the most complicated formulas. Translate your Excel files in 28 lanugages. Write and explain your VBA and Google Apps Scripts. Register for free!

Start Generating Formulas

Struggling with your Excel formulas?

Check out our blog for the latest tips and tricks to help you become an expert. We have the insider scoop on the best strategies and resources to help you stay ahead of the curve. Click here to read our blog and start your journey towards Excel and Google Sheets mastery today!

Explore our blog