AbdulkareemAlhassni
New Member
- Joined
- Nov 16, 2018
- Messages
- 41
Hey guys,
can someone tell me please why this file is not working?
https://sheet.zoho.com/sheet/editor...0b6f8e188e67294c4ed9a2e62d8dd325f910d1a209e47
am using ( =INDEX(D4:D19,MATCH(1,(H3=B4:B19))*(I3=C4:C19),0) )
but for some reeason i keep getting #N/A
and yes am using CTRL+SHIFT+ENTER
<colgroup><col span="3"><col><col><col span="4"></colgroup><tbody>
</tbody>
can someone tell me please why this file is not working?
https://sheet.zoho.com/sheet/editor...0b6f8e188e67294c4ed9a2e62d8dd325f910d1a209e47
am using ( =INDEX(D4:D19,MATCH(1,(H3=B4:B19))*(I3=C4:C19),0) )
but for some reeason i keep getting #N/A
and yes am using CTRL+SHIFT+ENTER
Number | Line | |||||||
Number | Line | Activity Code | 4559 | 2 | #N/A | |||
4559 | 1 | 564 | ||||||
4559 | 2 | 16 | ||||||
4559 | 3 | 231 | ||||||
4559 | 4 | 32 | ||||||
4560 | 1 | 5 | ||||||
4560 | 2 | 65 | ||||||
4560 | 3 | 165 | ||||||
4560 | 4 | 165 | ||||||
4560 | 5 | 16 | ||||||
4560 | 6 | 51 | ||||||
4560 | 7 | 1 | ||||||
4560 | 8 | 651 | ||||||
4560 | 9 | 61 | ||||||
4558 | 1 | 651651 | ||||||
4558 | 2 | 26 | ||||||
4558 | 3 | 2 |
<colgroup><col span="3"><col><col><col span="4"></colgroup><tbody>
</tbody>