Search for a value in a vertically-arranged data set.
Syntax:
VLOOKUP(key, array, column_index:number)
Looks up the given key value in the first column of the array and returns the corresponding value in that array or range of cells from the column specified by column_index.
array must be a vertically-arranged set of data, sorted in ascending order.
column_index=1
would yield a return value from the first column in the array.
column_index=2
would yield a return value from the second column, and so on.
If key is not found, the closest lower value is returned.