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

Data Analysis

  • Conditional Formatting Icon Sets Examples in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • How to Sort by Color in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel

References

  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • How to get last row in text data in Excel
  • How to retrieve first match between two ranges in Excel
  • Offset in Excel

Data Validations

  • Excel Data validation whole percentage only
  • Excel Data validation date in specific year
  • Excel Data validation specific characters only
  • Excel Data validation must begin with
  • Excel Data validation don’t exceed total

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:

AVERAGE 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 Excel NOT Function
  • OR function Examples in Excel
  • Not Equal To ‘<>‘ operator in Excel
  • Excel If, Nested If, And/Or Criteria Examples
  • NOT function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Convert date to text in Excel
  • Count birthdays by month in Excel
  • WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation
  • DAYS360 function: Description, Usage, Syntax, Examples and Explanation
  • Series of dates by day

Grouping

  • Group arbitrary text values in Excel
  • Map text to numbers in Excel
  • Group times into unequal buckets in Excel
  • Map inputs to arbitrary values in Excel
  • Group numbers with VLOOKUP in Excel

General

  • How to Delete Cells, Row and Rows in Excel
  • How to create dynamic worksheet reference in Excel
  • Delete Blank Rows at Once in Excel
  • How to calculate percent change in Excel
  • Excel Default Templates
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning