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

						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>

 

[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