# What does Vlookup mean in Excel?

**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.

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**

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