INDEX MATCH wrong value

[SH1988]

Hi need your help with the func that return the wrong numbers for part of my cells.
my func :
{=INDEX($C$5:$C$18044,MATCH(MAX(IF($B$5:$B$18044=B6,$E$5:$E$18044)),$E$5:$E$18044,0))}
My Data looks like this:

[TABLE="width: 865"]
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]MailingType[/TD]
[TD]MailingJN[/TD]
[TD]Report Date[/TD]
[TD]MailingDate W/E[/TD]
[TD] Issue Count By Date [/TD]
[TD] date of the highest Issue count [/TD]
[/TR]
[TR]
[TD]ADD Inq[/TD]
[TD]M268[/TD]
[TD="align: right"]09/15/2018[/TD]
[TD="align: right"]09/14/2018[/TD]
[TD][/TD]
[TD="align: right"]10/06/2018[/TD]
[/TR]
[TR]
[TD]ADD Inq[/TD]
[TD]M268[/TD]
[TD="align: right"]09/22/2018[/TD]
[TD="align: right"]09/14/2018[/TD]
[TD] 4[/TD]
[TD="align: right"]10/06/2018[/TD]
[/TR]
[TR]
[TD]ADD Inq[/TD]
[TD]M268[/TD]
[TD="align: right"]09/29/2018[/TD]
[TD="align: right"]09/14/2018[/TD]
[TD] 132[/TD]
[TD="align: right"]10/06/2018[/TD]
[/TR]
[TR]
[TD]ADD Inq[/TD]
[TD]M268[/TD]
[TD="align: right"]10/06/2018[/TD]
[TD="align: right"]09/14/2018[/TD]
[TD] 290[/TD]
[TD="align: right"]10/06/2018[/TD]
[/TR]
[TR]
[TD]ADD Inq[/TD]
[TD]M268[/TD]
[TD="align: right"]10/13/2018[/TD]
[TD="align: right"]09/14/2018[/TD]
[TD] 148[/TD]
[TD="align: right"]10/06/2018[/TD]
[/TR]
[TR]
[TD]ADD Inq[/TD]
[TD]M268[/TD]
[TD="align: right"]10/20/2018[/TD]
[TD="align: right"]09/14/2018[/TD]
[TD] 77[/TD]
[TD="align: right"]10/06/2018[/TD]
[/TR]
[TR]
[TD]ADD Inq[/TD]
[TD]M268[/TD]
[TD="align: right"]10/27/2018[/TD]
[TD="align: right"]09/14/2018[/TD]
[TD] 33[/TD]
[TD="align: right"]10/06/2018[/TD]
[/TR]
[TR]
[TD]ADD Inq[/TD]
[TD]M268[/TD]
[TD="align: right"]11/03/2018[/TD]
[TD="align: right"]09/14/2018[/TD]
[TD] 18[/TD]
[TD="align: right"]10/06/2018[/TD]
[/TR]
[TR]
[TD]ADD Inq[/TD]
[TD]M268[/TD]
[TD="align: right"]11/10/2018[/TD]
[TD="align: right"]09/14/2018[/TD]
[TD] 28[/TD]
[TD="align: right"]10/06/2018[/TD]
[/TR]
[TR]
[TD]ADD Inq[/TD]
[TD]M268[/TD]
[TD="align: right"]11/17/2018[/TD]
[TD="align: right"]09/14/2018[/TD]
[TD] 12[/TD]
[TD="align: right"]10/06/2018

[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1042"]
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]JONAI[/TD]
[TD]L529[/TD]
[TD="align: right"]04/21/2018[/TD]
[TD="align: right"]04/20/2018[/TD]
[TD][/TD]
[TD="align: right"]06/23/2018[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]JONAI[/TD]
[TD]L529[/TD]
[TD="align: right"]04/28/2018[/TD]
[TD="align: right"]04/20/2018[/TD]
[TD] 3[/TD]
[TD="align: right"]06/23/2018[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]JONAI[/TD]
[TD]L529[/TD]
[TD="align: right"]05/05/2018[/TD]
[TD="align: right"]04/20/2018[/TD]
[TD] 11[/TD]
[TD="align: right"]06/23/2018[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]JONAI[/TD]
[TD]L529[/TD]
[TD="align: right"]05/12/2018[/TD]
[TD="align: right"]04/20/2018[/TD]
[TD] 12[/TD]
[TD="align: right"]06/23/2018[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]JONAI[/TD]
[TD]L529[/TD]
[TD="align: right"]05/19/2018[/TD]
[TD="align: right"]04/20/2018[/TD]
[TD] 17[/TD]
[TD="align: right"]06/23/2018[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]JONAI[/TD]
[TD]L529[/TD]
[TD="align: right"]05/26/2018[/TD]
[TD="align: right"]04/20/2018[/TD]
[TD] 9[/TD]
[TD="align: right"]06/23/2018[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]JONAI[/TD]
[TD]L529[/TD]
[TD="align: right"]06/02/2018[/TD]
[TD="align: right"]04/20/2018[/TD]
[TD] 4[/TD]
[TD="align: right"]06/23/2018[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]JONAI[/TD]
[TD]L529[/TD]
[TD="align: right"]06/09/2018[/TD]
[TD="align: right"]04/20/2018[/TD]
[TD] - [/TD]
[TD="align: right"]06/23/2018[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]JONAI[/TD]
[TD]L529[/TD]
[TD="align: right"]06/16/2018[/TD]
[TD="align: right"]04/20/2018[/TD]
[TD] - [/TD]
[TD="align: right"]06/23/2018[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]JONAI[/TD]
[TD]L529[/TD]
[TD="align: right"]06/23/2018[/TD]
[TD="align: right"]04/20/2018[/TD]
[TD] - [/TD]
[TD="align: right"]06/23/2018[/TD]
[TD="align: right"]64[/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Welcome to the MrExcel Board!

The formula as presented can return incorrect results if there is a tie on the Issue Count in different MailingJN's. Try:

Book1
	A	B	C	D	E	F	G
1
2
3
4	MailingType	MailingJN	Report Date	MailingDate W/E	Issue Count By Date	date of the highest Issue count
5	ADD Inq	M268	9/15/2018	9/14/2018		10/6/2018
6	ADD Inq	M268	9/22/2018	9/14/2018	4	10/6/2018
7	ADD Inq	M268	9/29/2018	9/14/2018	132	10/6/2018
8	ADD Inq	M268	10/6/2018	9/14/2018	290	10/6/2018
9	ADD Inq	M268	10/13/2018	9/14/2018	148	10/6/2018
10	ADD Inq	M268	10/20/2018	9/14/2018	77	10/6/2018
11	ADD Inq	M268	10/27/2018	9/14/2018	33	10/6/2018
12	ADD Inq	M268	11/3/2018	9/14/2018	18	10/6/2018
13	ADD Inq	M268	11/10/2018	9/14/2018	28	10/6/2018
14	ADD Inq	M268	11/17/2018	9/14/2018	12	10/6/2018
15						#N/A
16	JONAI	L529	4/21/2018	4/20/2018		5/19/2018	64
17	JONAI	L529	4/28/2018	4/20/2018	3	5/19/2018	64
18	JONAI	L529	5/5/2018	4/20/2018	11	5/19/2018	64
19	JONAI	L529	5/12/2018	4/20/2018	12	5/19/2018	64
20	JONAI	L529	5/19/2018	4/20/2018	17	5/19/2018	64
21	JONAI	L529	5/26/2018	4/20/2018	9	5/19/2018	64
22	JONAI	L529	6/2/2018	4/20/2018	4	5/19/2018	64
23	JONAI	L529	6/9/2018	4/20/2018	-	5/19/2018	64
24	JONAI	L529	6/16/2018	4/20/2018	-	5/19/2018	64
25	JONAI	L529	6/23/2018	4/20/2018	-	5/19/2018	64
Sheet2

Cell Formulas
Range	Formula
F5	{=INDEX($C$5:$C$18044,MATCH(B5&"|"&MAX(IF($B$5:$B$18044=B5,$E$5:$E$18044)),$B$5:$B$18044&"|"&$E$5:$E$18044,0))}
Press CTRL+SHIFT+ENTER to enter array formulas.