Please enable JavaScript to view the comments powered by Disqus.


How to use MATCH() with VLOOKUP() to get changing column offset.

The formula with MATCH() and VLOOKUP() works by checking for a criteria in a table with values that matches in extreme left column. This is done by MATCH() function. The result is feed to the third argument of VLOOKUP() and it returns the required 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


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