Please enable JavaScript to view the comments powered by Disqus.


How to use VLOOKUP() in excel.

This formula works by looks for a value in a table with values that matches in extreme left column. In order to provide column offset, we have used MATCH() function that can be easily replaced by a hard-coded value. In return the vlookup value is returned.

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


VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

Category: Lookup and reference

Looks up values in a reference or array


MATCH(lookup_value, lookup_array, [match_type])

Lets chat on this