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:

MailingType	MailingJN	Report Date	MailingDate W/E	Issue Count By Date	date of the highest Issue count
ADD Inq	M268	09/15/2018	09/14/2018		10/06/2018
ADD Inq	M268	09/22/2018	09/14/2018	4	10/06/2018
ADD Inq	M268	09/29/2018	09/14/2018	132	10/06/2018
ADD Inq	M268	10/06/2018	09/14/2018	290	10/06/2018
ADD Inq	M268	10/13/2018	09/14/2018	148	10/06/2018
ADD Inq	M268	10/20/2018	09/14/2018	77	10/06/2018
ADD Inq	M268	10/27/2018	09/14/2018	33	10/06/2018
ADD Inq	M268	11/03/2018	09/14/2018	18	10/06/2018
ADD Inq	M268	11/10/2018	09/14/2018	28	10/06/2018
ADD Inq	M268	11/17/2018	09/14/2018	12	10/06/2018

<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

JONAI	L529	04/21/2018	04/20/2018		06/23/2018	64
JONAI	L529	04/28/2018	04/20/2018	3	06/23/2018	64
JONAI	L529	05/05/2018	04/20/2018	11	06/23/2018	64
JONAI	L529	05/12/2018	04/20/2018	12	06/23/2018	64
JONAI	L529	05/19/2018	04/20/2018	17	06/23/2018	64
JONAI	L529	05/26/2018	04/20/2018	9	06/23/2018	64
JONAI	L529	06/02/2018	04/20/2018	4	06/23/2018	64
JONAI	L529	06/09/2018	04/20/2018	-	06/23/2018	64
JONAI	L529	06/16/2018	04/20/2018	-	06/23/2018	64
JONAI	L529	06/23/2018	04/20/2018	-	06/23/2018	64

<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

 

[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.