Please enable JavaScript to view the comments powered by Disqus.


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

MS Excel Vlookup explained

The function return the result by looking the value in a table and returing the corresponding value from a given column,  it start with looking values in 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.


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