What does Vlookup mean in Excel?

Asked By: Uta Whittingham | Last Updated: 12th March, 2020
Category: technology and computing databases
4.2/5 (135 Views . 17 Votes)
VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.

Click to see full answer


Also, why do you use Vlookup in Excel?

Vlookup (short for 'vertical' lookup) is a built-in Excel function that is designed to work with data that is organised into columns. For a specified value, the function finds (or 'looks up') the value in one column of data, and returns the corresponding value from another column.

Additionally, what is Vlookup and Hlookup in Excel? HLOOKUP and VLOOKUP are functions in Microsoft Excel that allow you to use a section of your spreadsheet as a lookup table. The V in VLOOKUP stands for vertical search (in a single column), while the H in HLOOKUP stands for horizontal search (within a single row).

Just so, what is Vlookup in Excel example?

The VLOOKUP function in Excel performs a case-insensitive lookup. For example, the VLOOKUP function below looks up MIA (cell G2) in the leftmost column of the table. Explanation: the VLOOKUP function is case-insensitive so it looks up MIA or Mia or mia or miA, etc.

How use Vlookup step by step?

How to use VLOOKUP in Excel

  1. Step 1: Organize the data.
  2. Step 2: Tell the function what to lookup.
  3. Step 3: Tell the function where to look.
  4. Step 4: Tell Excel what column to output the data from.
  5. Step 5: Exact or approximate match.

25 Related Question Answers Found

What is the correct Vlookup formula?

In its simplest form, the VLOOKUP function says: =VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).

What do you mean by lookup?

search, lookup(noun) an operation that determines whether one or more of a set of items has a specified property. "they wrote a program to do a table lookup"

Can pivot tables show text?

Pivot Table Text Values. Show text in the Pivot Table Values area, by using conditional formatting and custom number formats. Set this up manually or with a macro.

What is the difference between Vlookup and index match?

The main difference between VLOOKUP and INDEX MATCH is in column reference. VLOOKUP requires a static column reference whereas INDEX MATCH requires a dynamic column reference. INDEX MATCH allows you to click to choose which column you want to pull the value from. This leads to fewer errors.

How many types of lookups are there in Excel?


There are two forms of LOOKUP in Excel: Vector and Array. Each form is explained individually below.

How do I match data from two Excel spreadsheets?

How to Compare Two Sheets in Excel
  1. Start Compare Sheets.
  2. Step 1: Select your worksheets and ranges.
  3. Step 2: Specify the comparing mode.
  4. Step 3: Select the key columns (if there are any)
  5. Step 4: Choose your comparison options.

What are the functions of Excel?

To help you get started, here are 5 important Excel functions you should learn today.
  • The SUM Function. The sum function is the most used function when it comes to computing data on Excel.
  • The TEXT Function.
  • The VLOOKUP Function.
  • The AVERAGE Function.
  • The CONCATENATE Function.

What is Hlookup in Excel?

HLOOKUP stands for Horizontal Lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row.

What is the use of pivot table in Excel?

A pivot table is a data summarization tool that is used in the context of data processing. Pivot tables are used to summarize, sort, reorganize, group, count, total or average data stored in a database. It allows its users to transform columns into rows and rows into columns.

How does lookup work in Excel?


The Excel LOOKUP function performs an approximate match lookup in a one-column or one-row range, and returns the corresponding value from another one-column or one-row range. LOOKUP's default behavior makes it useful for solving certain problems in Excel. A value in the result vector.

What are the formulas in Excel?

Excel formulas and functions
  • =1+2 // returns 3.
  • =6/3 // returns 2.
  • =A1+A2+A3 // returns 9.
  • =B1+C1+D1 // formula in E1.
  • =A1 // relative reference =$A$1 // absolute reference.
  • =D1*$A$1 // formula in E1 =D2*$A$1 // formula in E2 =D3*$A$1 // formula in E3.
  • =SUM(1,2,3) // returns 6 =SUM(A1:A3) // returns A1+A2+A3.
  • =AVERAGE(1,2,3) // returns 2.

How do I match data in Excel?

Compare Two Columns and Highlight Matches
  1. Select the entire data set.
  2. Click the Home tab.
  3. In the Styles group, click on the 'Conditional Formatting' option.
  4. Hover the cursor on the Highlight Cell Rules option.
  5. Click on Duplicate Values.
  6. In the Duplicate Values dialog box, make sure 'Duplicate' is selected.

What's the difference between lookup and Vlookup?

The LOOKUP function. The function performs a rough match lookup either in a one-row or one-column range and returns the corresponding value from another one-row or one-column range. While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row.

What are the limitations of Vlookup?

Limitations of VLOOKUP
One major limitation of VLOOKUP is that it cannot look to the left. The values to lookup must always be on the left-most column of the range and the values to return must be on the right hand side. You cannot use the standard VLOOKUP to look at the columns and the rows to find an exact match.

What is IF function in Excel?


The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE. The IF function is a built-in function in Excel that is categorized as a Logical Function. As a worksheet function, the IF function can be entered as part of a formula in a cell of a worksheet.

Can I use Vlookup and Hlookup together?

We can use a nested formula that combines the VLOOKUP and HLOOKUP Functions in excel to retrieve values from a table. Approximate and exact matching is supported by this combined formula and wildcards (* ?) are for finding partial matches.

What is data validation in Excel?

Introduction. Data validation is a feature in Excel used to control what a user can enter into a cell. For example, you could use data validation to make sure a value is a number between 1 and 6, make sure a date occurs in the next 30 days, or make sure a text entry is less than 25 characters.