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

Data Analysis

  • Get column name from index in Excel Table
  • How to sum a total in multiple Excel tables
  • Error Bars in Excel
  • Conditional Formatting Data bars Examples in Excel
  • Create Scatter Chart in Excel

References

  • Convert text string to valid reference in Excel using Indirect function
  • How to get last row in mixed data with blanks in Excel
  • Perform case-sensitive Lookup in Excel
  • Lookup entire row in Excel
  • How to use Excel ROW Function

Data Validations

  • Excel Data validation require unique number
  • Data validation must not exist in list
  • Excel Data validation whole percentage only
  • Excel Data validation allow weekday only
  • Excel Data validation only dates between

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 return blank in place of #DIV/0! error in Excel
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel TRUE Function
  • How to use IFS function in Excel

Date Time

  • Two ways to sum time over 30 minutes in Excel
  • Convert date to month and year in Excel
  • Convert text date dd/mm/yy to mm/dd/yy in Excel
  • Display Days until expiration date in Excel
  • Get age from birthday in Excel

Grouping

  • Group times into unequal buckets in Excel
  • Group arbitrary text values in Excel
  • Running count group by n size in Excel
  • How to randomly assign data to groups in Excel
  • If cell contains one of many things in Excel

General

  • How to get original price from percentage discount in Excel
  • Excel Autofill Cell Ranges, Copy, Paste
  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • List sheet names with formula in Excel
  • Count cells that do not contain many strings in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning