Hi,
This Tip is an alternative for Two-Dimensional Lookup by using VLOOKUP & MATCH Functions.
The VLOOKUP function can only look from left to right, You look a value in one column in a table, and then return a value from a column to the right.
The MATCH function also has a simple job - look in a column of data and return the row number of a value that you specify.
We want to use these advantages of VLOOKUP & MATCH functions for Two-Dimensional Lookup as explained in the following example:
We have merit increases table that based on the annual performance rating of the employee and the position of his/her salary in the salary scale, we are aiming to get the merit increase percentage due to each employee by using the following Formula:
=VLOOKUP($B10;$A$1:$E$6;MATCH($C10;$A$1:$E$1;0);FALSE)
Attachment: VLOOKUP_MATCH_Function.xlsx
Bookmarks