Please enable JavaScript to view the comments powered by Disqus.


VLOOKUP(...C12,C4:D10,2,0)

Understanding how does a VLOOKUP() formula works.

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.


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])

Lets chat on this