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

Data Analysis

  • Chart Axes in Excel
  • Use Data Form to input, edit and delete records in Excel
  • Excel Pie Chart
  • Number and Text Filters Examples in Excel
  • How to count table columns in Excel

References

  • How to use Excel MATCH Function
  • How to use Excel OFFSET function
  • How to use Excel MMULT Function
  • Vlookup Examples in Excel
  • Count unique text values with criteria

Data Validations

  • Excel Data validation only dates between
  • Excel Data validation no punctuation
  • Excel Data validation must not contain
  • Excel Data validation allow weekday only
  • Excel Data validation date in next 30 days

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:   Extract data with helper column 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.

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

Logical Functions

  • How to use IFS function in Excel
  • OR function Examples in Excel
  • Complete List of Excel Logical Functions, References and Examples
  • How to use Excel NOT Function
  • How to return blank in place of #DIV/0! error in Excel

Date Time

  • WEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate percent of year complete in Excel
  • Convert decimal seconds to Excel time
  • Get month name from date in Excel
  • Get days between dates ignoring years in Excel

Grouping

  • Group numbers with VLOOKUP in Excel
  • Map text to numbers in Excel
  • How to randomly assign people to groups in Excel
  • If cell contains one of many things in Excel
  • Group arbitrary text values in Excel

General

  • How to calculate percentage discount in Excel
  • Find Most Frequently Occurring Word in Excel Worksheet
  • Excel Operators
  • How to get original number from percent change in Excel
  • Find, Trace and Correct Errors in Excel Formulas using ‘Formula Auditing’
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning