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:
- table – the table (range) from which to retrieve a value.
- cols – specifies the number of columns in the table (range).
- value – the value to look for in the first column of a table (range).
- index – the column in the table from which to retrieve a value.
- 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)