Please enable JavaScript to view the comments powered by Disqus.


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

How to do VLOOKUP() in MS Excel

The formula works by looking at the left most column for a criteria and return back from a selected table from a given column the corresponding value. With VLOOKUP() we can have either an exact or an approximate match for a criteria.


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