VLOOKUP(...)
How to use match value in a range with MATCH() and VLOOKUP()
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])
Practice VLOOKUP Formula at Sheetzoom
VLOOKUP formula at Microsoft helpCategory: Lookup and reference
Looks up values in a reference or array
Syntax
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.