20231121 Index Match Xlookup multiple criteria rjmdc.xlsx | ||||||
---|---|---|---|---|---|---|
E | F | G | H | |||
1 | Parameter | Number Format | Special Function | Check Type | ||
2 | MEDICAID FUNDED | 819647.4 | AgeRestriction | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F2 | F2 | =INDEX(tblBudgetAmounts[Amount], MATCH(1, (tblBudgetAmounts[Service]=[@Parameter]) * (tblBudgetAmounts[Budget Type] = "Amendment"), 0), 0)*12 |