VLOOKUP(...)
Understanding how does a VLOOKUP() formula works.
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() works by taking up four arguments. First one is the value to be looked up, The second one is the lookup range or lookup table. The third argument specifies the column offset. Remember that valookup numbers column from 1, and the first column is always the left most collumn, The fourth argument is if your are looking for exact match or not. So ti could be 1 or 0 or TRUE or FALSE.