Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel OFFSET function
  • Approximate match with multiple criteria in Excel
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to get address of first cell in range in Excel
  • Basic INDEX MATCH approximate in Excel

Data Analysis Examples

  • Everything about Charts in Excel
  • Understanding Pivot Tables in Excel
  • Working With Tables in Excel
  • Error Bars in Excel
  • Conditional Formatting Data bars Examples in Excel

Data Validation Examples

  • Excel Data validation no punctuation
  • Excel Data validation must not contain
  • How To Create Drop-down List in Excel
  • Excel Data validation don’t exceed total
  • Excel Data validation number multiple 100

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

Worked Example:   Create hyperlink with VLOOKUP in Excel

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.
Worked Example:   Basic Tax Rate calculation with VLOOKUP in Excel
Worked Example:   Partial match with VLOOKUP in Excel

Post navigation

Previous Post:

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

Next Post:

IF 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
  • How to get top level domain (TLD) in Excel
  • How to add a line break with a formula while joining text strings in Excel
  • Find most frequent text within a range with criteria in Excel
  • How to abbreviate names or words in Excel
  • Add line break based on OS in Excel
  • Get month name from date in Excel
  • WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation
  • How to get same date next year or previous year in Excel
  • Get first Monday before any date in Excel
  • Get days before a date in Excel
  • AMORDEGRC function: Description, Usage, Syntax, Examples and Explanation
  • XIRR function: Description, Usage, Syntax, Examples and Explanation
  • IPMT function: Description, Usage, Syntax, Examples and Explanation
  • PRICEDISC function: Description, Usage, Syntax, Examples and Explanation
  • PV function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles