Please enable JavaScript to view the comments powered by Disqus.


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

How to use VLOOKUP() in MS Excel

The formula works by  searching the value that is to be present in the left most column of a table. The formula looks for a certain column offset and fetches back the corresponding matched value. This formula has provision to give exact match or approximate match through its last argument that takes TRUE or FALSE to return a value.


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