Index match with one criterium in multiple columns

[Arjen Bakker]

Hello folks
unfortunately working with somehow strange set of data. See below.
Is it nevertheless possible to have a formula that shows people working
on day 3 with acivity "c" ? (Column I)
Thanks very much for your help Arjen A B C D E G H I 1 Code1 Code2 2 3 c 3 Wished 4 Code1 (work days) Code2 Name Result 5 1 2 3 5 c A A 6 1 2 4 a A NA 7 2 3 4 5 c C C 8 1 5 d C NA <colgroup><col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" span="8"> <tbody> </tbody> <tbody> </tbody>

<colgroup><col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" span="8"> <tbody> </tbody>

 

[iggy_]

Copy this into I5 and then copy down. =IF(ISNUMBER(MATCH($A$2,A5:E5,0))*ISNUMBER(MATCH($B$2,F5:F5,0)),G5,"NA")