Why this Match is not working, FILE ATTACHED

[AbdulkareemAlhassni]

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


[TABLE="width: 621"]
<colgroup><col span="3"><col><col><col span="4"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Number[/TD]
[TD]Line[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Number[/TD]
[TD]Line[/TD]
[TD]Activity Code[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4559[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: right"]4559[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]564[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4559[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4559[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]231[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4559[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]32[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4560[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4560[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]65[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4560[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]165[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4560[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]165[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4560[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4560[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]51[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4560[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4560[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]651[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4560[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]61[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4558[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]651651[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4558[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]26[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4558[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[sandy666]

maybe

=INDEX($D$4:$D$19,MATCH(1,(H3=$B$4:$B$19)*(I3=$C$4:$C$19),0))

with CSE

 

[AhoyNC]

Another option if you have Excel 2010 or later:
This does not require CSE just ENTER.

Excel Workbook
	B	C	D	E	F	G	H	I	J
1
2							Number	Line
3	Number	Line	Activity Code				4559	2	16
4	4559	1	564
5	4559	2	16
6	4559	3	231
7	4559	4	32
8	4560	1	5
9	4560	2	65
10	4560	3	165
11	4560	4	165
12	4560	5	16
13	4560	6	51
14	4560	7	1
15	4560	8	651
16	4560	9	61
17	4558	1	651651
18	4558	2	26
19	4558	3	2
20
Sheet

 

[AbdulkareemAlhassni]

maybe

=INDEX($D$4:$D$19,MATCH(1,(H3=$B$4:$B$19)*(I3=$C$4:$C$19),0))

with CSE

hhhhhhhhhhhhhhhhhhhhhhhhhh

i have been working for 2 hours trying to understand what is wrong and its only the $.

thanks alot brother <3

 

[sandy666]

... and too much brackets

Have a nice day