Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Use Solver Tool in Excel
  • Understanding Pivot Tables in Excel
  • Filter Data Based on Date in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • Excel Bar Chart

References

  • How to retrieve first match between two ranges in Excel
  • How to use Excel INDIRECT Function
  • Count rows with at least n matching values
  • How to use Excel ROWS Function
  • Two-column Lookup in Excel

Data Validations

  • Excel Data validation unique values only
  • Excel Data validation don’t exceed total
  • Excel Data validation with conditional list
  • Excel Data validation number multiple 100
  • Excel Data validation specific characters only

VLOOKUP function: Description, Usage, Syntax, Examples and Explanation

by

What is VLOOKUP function in Excel?

VLOOKUP function is one of the lookup and reference functions in Microsoft office Excel that is used when you need to find things in a table or a range by row.

For instance, look up a price of an automotive part by the part number.

In its simplest form, the VLOOKUP function says:

=VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE).

Syntax of VLOOKUP function

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

VLOOKUP formula explanation

There are four pieces of information that you will need in order to build the VLOOKUP syntax:

=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, optionally specify TRUE for approximate match or FALSE for an exact match).

  1. The value you want to look up, also called the lookup value.
  2. The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example, if your lookup value is in cell C2 then your range should start with C.
  3. The column number in the range that contains the return value. For example, if you specify B2: D11 as the range, you should count B as the first column, C as the second, and so on.
  4. Optionally, you can specify TRUE if you want an approximate match or FALSE if you want an exact match of the return value. If you don’t specify anything, the default value will always be TRUE or approximate match.

Post navigation

Previous Post:

CUBEVALUE function: Description, Usage, Syntax, Examples and Explanation

Next Post:

CLEAN function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use IFS function in Excel
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel
  • IF with wildcards in Excel

Date Time

  • DAY function: Description, Usage, Syntax, Examples and Explanation
  • Get day name from date in Excel
  • Get date from day number in Excel
  • How to calculate Day of the Year in Excel
  • How to calculate next scheduled event in Excel

Grouping

  • Categorize text with keywords in Excel
  • Group numbers at uneven intervals in Excel
  • If cell contains one of many things in Excel
  • Running count group by n size in Excel
  • How to randomly assign data to groups in Excel

General

  • Zoom Worksheet in Excel
  • Excel Operators
  • Automatically fill series of cells in Excel using AutoFill
  • Advanced Number Formats in Excel
  • Flash Fill in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning