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>