VLOOKUP
Use HLOOKUP and VLOOKUP to find values in large lists. Use HLOOKUP to search in rows and VLOOKUP to search in columns.
The function searches the left column of a table or array for a value that you specify. That is, it searches the row headings. If it finds the specified value it returns a value from a specified column in the same row.
To look for an exact match for the value that you enter, specify
TRUE as the value of the range_lookup parameter. To use TRUE, your data must be
sorted in ascending order.
Syntax
VLOOKUP(lookup_value, table_array,column_index_number
[,range_lookup=TRUE])
Lookup_value can be a reference to a cell containing the value to look up.
Table_array is a range of cells.
The column_index_number is the number of the column from which the value is returned.
Example
| Product A | Product B | Product C | Product D | |
|---|---|---|---|---|
| Region 1 | 76 | 67 | 58 | 57 |
| Region 2 | 59 | 71 | 52 | 55 |
| Region 3 | 75 | 45 | 69 | 43 |
| Region 4 | 12 | 44 | 17 | 28 |
Cell Y20 contains Region 2.
This function returns 71, the value in the third column of the row for Region 2:
=VLOOKUP(Y20,A1:E5,3,TRUE)