June 16, 2015
January 31, 2022
The syntax for INDEX and MATCH was incorrect. INDEX takes an array and then a row and a column reference. The row and column numbers are, in turn, determined by MATCH.
An exact MATCH of the value in the Entity column of the Master with the Entity row headers in the Model will return the row number.
An exact MATCH of the value in the Rating column of the Master with the Rating column headers in the Model will return the column number.
The zero at the end of each MATCH formula means that you want an exact match.
The attached file contains the formulas you need. At least, I believe that is so. Was insecure about the payout formula though and made something up myself 🙂