VLOOKUP(...)
How to use MATCH() with VLOOKUP() to get changing column offset.
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
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.