Need help to correct formula

[RAJESH1960]

Hello experts

I am trying to get the matching dates of rows which have both the name and No. in common from a different sheet. I have tried entering this formula but something seems to be wrong. Need your expert advice to solve the problem.

=IF(COUNTIFS(Sheet2!I$13:I$35,Sheet1!A2,Sheet2!J$13:J$35,Sheet1!B2,Sheet2!K13,"")

Book1
	I	J	K
1
2
3
4
5
6
7
8
9
10
11
12	NAME	NO	date
13	April	4	04-08-2021
14	April	3	15-08-2021
15	August	8	08-08-2021
16	August	7	19-08-2021
17	December	12	12-08-2021
18	December	11	23-08-2021
19	February	2	02-08-2021
20	February	1	13-08-2021
21	January	1	01-08-2021
22	July	7	07-08-2021
23	July	6	18-08-2021
24	June	6	06-08-2021
25	June	5	17-08-2021
26	March	3	03-08-2021
27	March	2	14-08-2021
28	May	5	05-08-2021
29	May	4	16-08-2021
30	November	11	11-08-2021
31	November	10	22-08-2021
32	October	10	10-08-2021
33	October	9	21-08-2021
34	September	9	09-08-2021
35	September	8	20-08-2021
Sheet2

Book1
	A	B	C
1	NAME	NO.	GET DATE HERE
2	April	4
3	April	3
4	August	8
5	August	7
6	December	12
7	December	11
8	February	2
9	February	1
10	January	1
11	July	7
12	July	6
13	June	6
14	June	5
15	March	3
16	March	2
17	May	5
18	May	4
19	November	11
20	November	10
21	October	10
22	October	9
23	September	9
24	September	8
Sheet1

 

[RAJESH1960]

Found the mistake. Missed a parenthesis. '=IF(COUNTIFS(Sheet2!I$13:I$35,Sheet1!A2,Sheet2!J$13:J$35,Sheet1!B2,Sheet2!K13,"")

 

[JGordon11]

=INDEX(Sheet2!$K$13:$K$35,MATCH(1,(Sheet1!A2=Sheet2!$I$13:$I$35)*(Sheet1!B2=Sheet2!$J$13:$J$35),0))

in C2 on Sheet1 and drag down

 

[RAJESH1960]

=INDEX(Sheet2!$K$13:$K$35,MATCH(1,(Sheet1!A2=Sheet2!$I$13:$I$35)*(Sheet1!B2=Sheet2!$J$13:$J$35),0))

in C2 on Sheet1 and drag down

I am getting a value error. But the problem is resolved. Thanks for your effort JGordon11.?