» Retrieving Matching Values From Not Adjacent List
Columns A & B contain numbers and matching letters.
However, rather than being adjacent, each letter in column B is shifted down one row with respect to its matching number in column A.
We want to retrieve the matching letter for each number.
Use the INDEX and MATCH functions as shown in the following formula: