The formula looks given value in a table with values that matches in extreme left column. In order to provide column offset, we have used MATCH() function that can be easily replaced by a hard-coded value. In return the vlookup value is returned.
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])
Looks up values in a reference or array
MATCH(lookup_value, lookup_array, [match_type])
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM