Problem with formula: Replace with code

[Aretradeser]

I have some data in an Excel sheet (sheet1), in column 2, name records; and, from column 3 to 14, the months of the year with number records.
On sheet2, from column 10 to 21, in row 4, the following formula:

INDICE(Sheet1!$B$3:$N$25;COINCIDIR(0;Sheet1!$C$3:$C$25;0);1)

which detects which name has a zero and records it where that match exists.
The problem occurs when there is more than one name with zero records, it only records the first one it finds, not the rest.
Example:
On sheet2, column10, row3, in January, it only records name10, when names12 and 13, 17, 18, 20 and 22 also meet this criterion. If I drag the formula down, it still records name10. and so it happens with all months.
Could this be solved with lines of code that would register all the names that meet this condition (zero registration)?
Thanks

Libro1
	B	C	D	E	F	G	H	I	J	K	L	M	N
2	NAMES	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
3	Name1	2	3	0	3	5	7	1	0	2	3	0	10
4	Name2	2	2	10	6	14	0	12	3	0	0	9	10
5	Name3	2	4	5	6	0	4	0	10	6	2	4	0
6	Name4	2	1	4	1	1	14	8	7	13	0	6	0
7	Name5	2	2	7	3	6	11	4	0	14	14	1	14
8	Name6	1	3	5	7	3	14	0	0	11	14	0	4
9	Name7	2	2	7	8	10	12	1	12	0	5	13	8
10	Name8	2	3	3	0	4	0	1	4	6	0	0	0
11	Name9	2	4	0	0	13	11	9	9	10	3	9	5
12	Name10	0	4	3	10	10	0	13	1	8	9	9	3
13	Name11	2	0	5	0	6	8	0	0	8	5	3	4
14	Name12	0	2	3	1	3	10	8	13	6	7	10	0
15	Name13	0	1	9	7	14	12	10	0	6	7	0	4
16	Name14	1	0	4	9	0	13	0	5	0	0	2	4
17	Name15	1	0	9	7	13	0	0	12	10	13	0	3
18	Name16	2	3	8	9	11	6	1	0	0	10	0	0
19	Name17	0	9	0	1	9	12	11	14	7	12	0	0
20	Name18	0	5	9	4	7	10	4	3	11	4	9	13
21	Name19	1	0	0	5	4	7	7	0	0	0	0	1
22	Name20	0	6	1	2	11	3	0	3	2	11	3	5
23	Name21	6	2	1	7	0	6	6	0	1	0	0	8
24	Name22	0	6	7	8	10	0	0	1	0	0	3	7
25	Name23	2	8	1	3	5	3	4	10	7	0	10	0
Hoja1

Libro1
	J	K	L	M	N	O	P	Q	R	S	T	U
3	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
4	Name10	Name11	Name1	Name8	Name3	Name2	Name3	Name1	Name2	Name2	Name1	Name3
5	Name10
6	Name10
7	Name10
8
Hoja2

Cell Formulas
Range	Formula
K4:U4	K4	=INDEX(Hoja1!$B$3:$N$25,MATCH(0,Hoja1!D3:D25,0),1)
J4:J7	J4	=INDEX(Hoja1!$B$3:$N$25,MATCH(0,Hoja1!$C$3:$C$25,0),1)

 

[jasonb75]

The problem occurs when there is more than one name with zero records, it only records the first one it finds, not the rest.

Because that is how the MATCH function works, it tells you this in the help file. You don't need code for such a simple task, just the correct formula. Note that this is done on the same sheet as the source table so you will need to add sheet names if you're using 2 sheets.

Book1
	P	Q	R	S	T	U	V	W	X	Y	Z	AA
2	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
3	Name10	Name11	Name1	Name8	Name3	Name2	Name3	Name1	Name2	Name2	Name1	Name3
4	Name12	Name14	Name9	Name9	Name14	Name8	Name6	Name5	Name7	Name4	Name6	Name4
5	Name13	Name15	Name17	Name11	Name21	Name10	Name11	Name6	Name14	Name8	Name8	Name8
6	Name17	Name19	Name19			Name15	Name14	Name11	Name16	Name14	Name13	Name12
7	Name18					Name22	Name15	Name13	Name19	Name19	Name15	Name16
8	Name20						Name20	Name16	Name22	Name21	Name16	Name17
9	Name22						Name22	Name19		Name22	Name17	Name23
10								Name21		Name23	Name19
11											Name21
12
Sheet1

Cell Formulas
Range	Formula
P3:AA12	P3	=IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($B$3:$B$25)/(C$3:C$25=0),ROWS(P$3:P3))),"")

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

+Fluff 1.xlsm
	J	K	L	M	N	O	P	Q	R	S	T	U
3	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
4	Name10	Name11	Name1	Name8	Name3	Name2	Name3	Name1	Name2	Name2	Name1	Name3
5	Name12	Name14	Name9	Name9	Name14	Name8	Name6	Name5	Name7	Name4	Name6	Name4
6	Name13	Name15	Name17	Name11	Name21	Name10	Name11	Name6	Name14	Name8	Name8	Name8
7	Name17	Name19	Name19			Name15	Name14	Name11	Name16	Name14	Name13	Name12
8	Name18					Name22	Name15	Name13	Name19	Name19	Name15	Name16
9	Name20						Name20	Name16	Name22	Name21	Name16	Name17
10	Name22						Name22	Name19		Name22	Name17	Name23
11								Name21		Name23	Name19
12											Name21
13
Sheet2

Cell Formulas
Range	Formula
J4:U13	J4	=IFERROR(INDEX(Sheet1!$B$3:$B$25,AGGREGATE(15,6,(ROW(Sheet1!$B$3:$B$25)-ROW(Sheet1!$B$3)+1)/(Sheet1!C$3:C$25=0),ROWS(J$4:J4))),"")

 

[Aretradeser]

jasonb 75 and Fluff, thank you for your quick and accurate responses. The formulas work perfectly. However, I see a small practical problem with them.
Currently, I have about 1200 records and, with the application of formulas, I have to drag them until I reach the last row of the column in which there are no more records that meet this condition. I could do the same with code and when I execute it with a button, it would do the same and, in addition, it would register the new names that meet this requirement.
In any case, I thank you for having put your time and knowledge into this project.

 

[Fluff]

Glad we could help & thanks for the feedback.