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])
0
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.