Hello,
I have a scoring matrix which I'm trying to use to assign a numerical value. I need a formula for Column D that will look up both on the x and y value. So, I want the results in Column D to automatically recalculate as updates to columns B and C are entered. Here's what it looks like:
<tbody>
</tbody>
I have a scoring matrix which I'm trying to use to assign a numerical value. I need a formula for Column D that will look up both on the x and y value. So, I want the results in Column D to automatically recalculate as updates to columns B and C are entered. Here's what it looks like:
| A | B | C | D | |
| 1 | Project | Y Score | X Score | Matrix Score |
| 2 | Project 1 | 2 | 3 | 3 |
| 3 | Project 2 | 4 | 1 | 12 |
| 4 | Project 3 | 1 | 3 | 1 |
| 5 | ||||
| 6 | Matrix | 1 | 2 | 3 |
| 7 | 1 | 7 | 2 | 1 |
| 8 | 2 | 8 | 4 | 3 |
| 9 | 3 | 11 | 6 | 5 |
| 10 | 4 | 12 | 10 | 9 |
| 11 |
<tbody>
</tbody>
