VLOOKUP(...)
An example of using VLOOKUP() with MATCH()
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
Here the formula works by checking for a criteria in a table with values that matches in extreme left column. In order to get column offset, MATCH() function is being used that can be easily replaced by a hard-coded value. Lastly the vlookup value is returned.