Advanced Excel
  • Introduction to Excel
  • Security
  • Short Keys
  • Practice Data Sheets
  • Data Formats
  • Conditional Formatting
  • Format as Table
  • Data Sorting
  • Data Filtering
  • Remove Duplicates
  • Data Validation
  • Text-To-Columns
  • Data Consolidation
  • What-if-Analysis
  • Grouping
  • Absolute & Relative Referencing
  • Mathematical Functions - Sum, Sumif, Sumifs, Count, Counta, Countif, Max, Min, Average
  • Task1 - Mathematical Formulas
  • Logical Functions - IF, IFERROR, AND, OR
  • Date Time Functions - Date, Year, Month, Day, Time, Hour, Minute, Second, Today, Now, Datedif
  • Text Functions - Proper, Left, Right, Concatenate, Exact, Find, Search, Mid, Replace, Text, Replace
  • Vlookup Formula
  • Task2 - Vlookup Problems
  • Vlookup with Match Formula - Dynamic Duo
  • Vlookup using (*) example
  • Vlookup with Running Countif
  • Task3 - Vlookup, Running Countif Problem
  • Lookup Functions - Hlookup, Index Match
  • Lookup Functions - Indirect, Offset
  • Vlookup-Indirect Example
  • Sumif, Indirect, Offset, Match Example
  • Array Functions
  • Task4 - Array Problem
  • Advanced Conditional Formatting using Formula
  • Data Validation using Indirect Function
  • Charts, Waterfall Graph
  • Pivot Table, Dashboards
Powered by GitBook
On this page

Was this helpful?

Vlookup Formula

Summary

VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.

Purpose

Lookup a value in a table by matching on the first column

Return Value

The matched value from a table.

Syntax

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

Arguments

  • look_value - The value to look for in the first column of a table.

  • table_array - The table from which to retrieve a value.

  • col_index - The column in the table from which to retrieve a value.

  • range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.

PreviousText Functions - Proper, Left, Right, Concatenate, Exact, Find, Search, Mid, Replace, Text, ReplaceNextTask2 - Vlookup Problems

Last updated 6 years ago

Was this helpful?

11KB
Vlookup formula.xlsx
Vlookup Formula