Hi
Please can anyone help me with the formula for INDEX MATCH with two lots of criteria.
Data:
<tbody>
</tbody>
Criteria:
<tbody>
</tbody>
I've used the formula below but there seems to be a problem.
=INDEX($C$2:$C$13,MATCH(A17,$A$2:$A$13,0)*MATCH(B17,$B$2:$B$13,0))
Can anyone tell me where I am going wrong or if there is a better formula to use. My actual data is 000s of rows.
Please can anyone help me with the formula for INDEX MATCH with two lots of criteria.
Data:
Site | Code | Supplier |
A | A0001 | Company X |
B | A0001 | Company Y |
C | A0001 | Company C |
D | A0001 | Company Y |
B | A0002 | Company X |
B | A0003 | Company A |
D | A0002 | Company B |
<tbody>
</tbody>
Criteria:
Site | Code | Supplier/RESULT |
A | A0001 | Company X |
B | A0001 | Company Y |
C | A0001 | Company C |
D | A0001 | Company Y |
B | A0002 | 0 |
B | A0003 | 0 |
D | A0002 | #REF! |
<tbody>
</tbody>
I've used the formula below but there seems to be a problem.
=INDEX($C$2:$C$13,MATCH(A17,$A$2:$A$13,0)*MATCH(B17,$B$2:$B$13,0))
Can anyone tell me where I am going wrong or if there is a better formula to use. My actual data is 000s of rows.