I am looking for a formula that matches two unique numbers in a table based on two numbers that are entered in two other cells. This will be clearer by looking at the example below and the attached.
The goal is to find the number entered for the home field (cell c2) in the "home" row (B5:K5) with the number entered for the away field (cell c3) in the "away" column (A6:A15) and result in the data element where the row and columns come together. The expected result for this example in the attached would be "JPD".
Another example would be if a 6 was in cell c2 and an 8 was in c3, the expected result would be "RBK". I think this can be done by indexing and matching but my memory has gone blank with how this works.
Any help would be SUPER...no pun.
Bookmarks