Hi, Based on the attached file, what makes my INDEX MATCH formula doesn't work to return value in the lookup tab.
Appreciate if someone can advice the correct way of using the Index Match for the attached file
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 🙂
