Pineapple_Crazy
Board Regular
- Joined
- May 2, 2017
- Messages
- 51
Hello,
I'm trying to match on 3 criteria to return a result, but no matter what I have tried it hasn't worked. In the example attached I am trying to match "Rms Cable Television", "Jan-18", and "ACTUAL" (all in bold below), to return a value. The formula I am attempting to use is =INDEX(C3:AB50,MATCH(B2,C3:C50,0),MATCH(B3,C3:AB3,0),MATCH(B4,C4:AB4,0)) (shown in #REF ! area below which would be in cell A2). The criteria "Rms Cable Television", "Jan-18", and "ACTUAL" start in cell B2. In the particular example provided I have in bold the criteria in the data set I am trying to match. I am trying to receive the value of 0.62. Would someone suggest a good formula for the way this data is set up in the workbook to achieve the desired result ? The formula seems to work for 2 criteria, but not for 3. Thanks so much!
PC
<tbody>
</tbody>
I'm trying to match on 3 criteria to return a result, but no matter what I have tried it hasn't worked. In the example attached I am trying to match "Rms Cable Television", "Jan-18", and "ACTUAL" (all in bold below), to return a value. The formula I am attempting to use is =INDEX(C3:AB50,MATCH(B2,C3:C50,0),MATCH(B3,C3:AB3,0),MATCH(B4,C4:AB4,0)) (shown in #REF ! area below which would be in cell A2). The criteria "Rms Cable Television", "Jan-18", and "ACTUAL" start in cell B2. In the particular example provided I have in bold the criteria in the data set I am trying to match. I am trying to receive the value of 0.62. Would someone suggest a good formula for the way this data is set up in the workbook to achieve the desired result ? The formula seems to work for 2 criteria, but not for 3. Thanks so much!
PC
Rooms Department - ACTUAL | |||||||||||||||||
#REF ! | Rms Cable Television | ||||||||||||||||
Jan-18 | Available Rooms | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | |
ACTUAL | Occupied Rooms | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | Budget | Budget | Budget | Budget | ACTUAL | BUDGET | BUDGET | |
Payroll | |||||||||||||||||
Rms Payroll | 33.68 | 31.32 | 35.57 | 34.60 | 36.13 | 36.80 | 41.00 | 39.53 | 35.06 | 32.64 | 29.33 | 30.58 | 33.81 | 32.60 | 39.06 | ||
Rms Benefits | 4.38 | 4.00 | 4.47 | 3.99 | 3.89 | 3.61 | 4.50 | 4.21 | 4.25 | 3.81 | 3.51 | 3.55 | 3.69 | 3.86 | 4.22 | ||
Rms Payroll Taxes | 4.09 | 3.79 | 4.12 | 3.91 | 4.10 | 4.16 | 4.64 | 4.60 | 4.07 | 3.79 | 3.40 | 3.55 | 3.94 | 3.80 | 4.55 | ||
Rms Total Payroll & Related | 42.15 | 39.11 | 44.17 | 42.50 | 44.12 | 44.57 | 50.14 | 48.34 | 43.38 | 40.24 | 36.25 | 37.68 | 41.44 | 40.26 | 47.83 | ||
Expenses | |||||||||||||||||
Rms Cable Television | 0.77 | 0.80 | 0.72 | 0.70 | 0.76 | 0.77 | 0.76 | 0.75 | 0.85 | 0.81 | 0.71 | 0.76 | 0.62 | 0.64 | 0.83 | ||
Rms Cleaning Supplies | 0.25 | 1.14 | 1.33 | 0.63 | 1.60 | 0.53 | 1.11 | 1.62 | 0.66 | 0.63 | 0.55 | 0.59 | 0.65 | 0.67 | 0.87 | ||
Rms Commissions GDS | 1.01 | 1.58 | (1.04) | - | - | - | - | - | 0.81 | 0.77 | 0.67 | 0.72 | - | - | - |
<tbody>
</tbody>