formula works on column but not another column

[abdelfattah]

hi, i have formula works in col g based on col a,b but when i would work col w based on d, e it doesn't work i hope somebody help

إدراج الاسماء تلقائي.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	teacherr	date				cuurent	2022													current			2020
2	teacher1	2019/01/01
3	teacher2	2019/03/01		teacher	date		teacher																teacher
4	teacher3	2019/05/01		teacher1	2019/01/01		teacher19
5	teacher4	2019/07/01		teacher2	2019/03/01		teacher20
6	teacher5	2019/09/01		teacher3	2019/05/01		teacher21
7	teacher6	2019/11/01		teacher4	2019/07/01		teacher22
8	teacher7	2020/01/01		teacher5	2019/09/01
9	teacher8	2020/03/01		teacher6	2019/11/01
10	teacher9	2020/05/01		teacher7	2020/01/01
11	teacher10	2020/07/01		teacher8	2020/03/01
12	teacher11	2020/09/01		teacher9	2020/05/01
13	teacher12	2020/11/01		teacher10	2020/07/01
14	teacher13	2021/01/01		teacher11	2020/09/01
15	teacher14	2021/03/01		teacher12	2020/11/01
16	teacher15	2021/05/01		teacher13	2021/01/01
17	teacher16	2021/07/01		teacher14	2021/03/01
18	teacher17	2021/09/01		teacher15	2021/05/01
19	teacher18	2021/11/01		teacher16	2021/07/01
20	teacher19	2022/01/01		teacher17	2021/09/01
21	teacher20	2022/03/01		teacher18	2021/11/01
22	teacher21	2022/05/01		teacher19	2022/01/01
23	teacher22	2022/07/01		teacher20	2022/03/01
24				teacher21	2022/05/01
Sheet1

Cell Formulas
Range	Formula
W4	W4	=IFERROR(INDEX($D$4:$D$170, MATCH(0,COUNTIF($W$3:W3, IF(($W$1=YEAR($E$4:$E$170)), $D$4:$D$170, $W$3)), 0)), "")
W5:W9	W5	=IFERROR(INDEX($D$2:$D$170, MATCH(0,COUNTIF($W$3:W4, IF(($W$1=YEAR($B$2:$B$170)), $D$2:$D$170, $W$3)), 0)), "")
G4:G24	G4	=IFERROR(INDEX($A$2:$A$170, MATCH(0,COUNTIF($G$3:G3, IF(($G$1=YEAR($B$2:$B$170)), $A$2:$A$170, $G$3)), 0)), "")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[FormR]

Hi, its an array formula - did you remember to commit it using CTRL+SHIFT+ENTER?

 

[abdelfattah]

ah! sorry i forgot it now it works thanks so much