Please enable JavaScript to view the comments powered by Disqus.


How to use match value in a range with MATCH() and VLOOKUP()

In order to match the criteria in a range of columns, (say, A:Z), we will use MATCH() function. This value is feed as the third argument of VLOOKUP() function. The VLOOKUP() itself looks into the extreme left column of the table and returns the value from the mentioned column. 

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