VLOOKUP

You are here:
Function name VLOOKUP
Type Search
Arguments – table
– value
– index
– exactmatch
Syntax =VLOOKUP(table, value, index, exactmatch)
Description Searches down and retrieve data from a specific column in table.

The Arguments description:

  1. table – the table (range) from which to retrieve a value.
  2. value – the value to look for in the first column of a table (range).
  3. index – the column in the table from which to retrieve a value.
  4. exactmatch – optional. If set to TRUE – approximate match (default) is returned. If set to FALSE – exact match is returned.

Examples:

=VLOOKUP([A1:B5],D1,2)

VLOOKUP in TotalSheets