I have 2 worksheets and I need some help, please!
<TBODY>
</TBODY>
In Worksheet 1 (above) I require a number added to Column L that is calculated from the data in Columns G and J against the data in the second Worksheet entitled TNPA.
In the example above L5 should read 1; L6 should read 2 and L7 should read 4.
I applied the formula =IFERROR(INDEX(TNPA!$C$2:$G$6,MATCH(G5,TNPA!$B$2:$B$6,0),MATCH(J5,TNPA!$C$7:$G$7,0)),"")
but it returns nothing!
</SPAN></SPAN>
<TBODY>
</TBODY>TNPA Worksheet
Any help or ideas greatly appreciated!
Many thanks
COL A | COL B | COL E | COL F | COL G | COL H | COL I | COL J | COL L | |
ROW 1 | |||||||||
ROW 2 | TASK | UNIT | FREQ | DIFF | PC | RISK 1 | RISK 2 | RISK | |
ROW 3 | |||||||||
ROW 4 | |||||||||
ROW 5 | 1 | AAA | 1 | 1 | 1 | 1 | 1 | 1 | |
ROW 6 | 2 | BBB | 1 | 2 | 2 | 1 | 1 | 1 | |
ROW 7 | 3 | CCC | 1 | 3 | 3 | 1 | 1 | 1 |
<TBODY>
</TBODY>
In Worksheet 1 (above) I require a number added to Column L that is calculated from the data in Columns G and J against the data in the second Worksheet entitled TNPA.
In the example above L5 should read 1; L6 should read 2 and L7 should read 4.
I applied the formula =IFERROR(INDEX(TNPA!$C$2:$G$6,MATCH(G5,TNPA!$B$2:$B$6,0),MATCH(J5,TNPA!$C$7:$G$7,0)),"")
but it returns nothing!
</SPAN></SPAN>
COL A | COL B | COL C | COL D | COL E | COL F | COL G | |
ROW 1 | |||||||
ROW 2 | PC | 5 | 9 | 10 | 11 | 12 | 13 |
ROW 3 | PC | 4 | 6 | 7 | 8 | 10 | 12 |
ROW 4 | PC | 3 | 4 | 5 | 7 | 8 | 11 |
ROW 5 | PC | 2 | 2 | 3 | 5 | 7 | 10 |
ROW 6 | PC | 1 | 1 | 2 | 4 | 6 | 9 |
ROW 7 | 1 | 2 | 3 | 4 | 5+ | ||
ROW 8 | RISK | RISK | RISK | RISK | RISK |
<TBODY>
</TBODY>
Any help or ideas greatly appreciated!
Many thanks