VLOOKUP

You are here:
Function name VLOOKUP
Type Search
Arguments – table
– cols
– value
– index
– exactmatch
Syntax =VLOOKUP(table, cols, 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. cols – specifies the number of columns in the table (range).
  3. value – the value to look for in the first column of a table (range).
  4. index – the column in the table from which to retrieve a value.
  5. exactmatch – optional. If set to TRUE – approximate match (default) is returned. If set to FALSE – exact match is returned.

Examples:

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

VLOOKUP in TotalSheets