VLOOKUP(...)
A VLOOKUP() example to bring values from a certain column
Used Functions
Category: Lookup and reference
Looks in the first column of an array and moves across the row to return the value of a cell
Syntax
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Practice VLOOKUP Formula at Sheetzoom
VLOOKUP formula at Microsoft help
0
The vlookup function works by looking the value in a table and returing the corresponding value from a given column. The formula looks for the given critieria in the first column of the table and then goes to the column number provided as the third argument of the formula. The formula can return an exact or approximate match according to the last argument.