Index Match Array Function to extract data based on multiple criteria

[MTS26]

All,

I am attempting to extract a series (5000 cells) of data based on 3 criteria: Name, Date and either Time or Fz. Becuase for each set of actual Data (Time and Fz), there is a name and a date of the same person associated


Here is the index match array formula I am currently using but it returns the wrong values except for when I use the last name on the list. At the moment I am only trying to extract one cell to verify the formula.

'=INDEX(Sheet5!$D$2:$D$11,MATCH(1,($A$15=Sheet5!$A$2:$A$11)*(CMJ!$K$62=Sheet5!$B$2:$B$11)*(CMJ!$A$1=Sheet5!$C$2:$C$11)))

Here is an example of what the table looks like. Table set up is probably part of the issue, I may need a better unique identifier

Matt	10/12/18	Time	.028
Matt	10/12/18	Fz	-24445

<tbody>
</tbody>

 

[Aladin Akyurek]

Given this:

Book1
	A	B	C	D
2	Matt	10/12/2018	Time	0.028
3	Matt	10/12/2018	Fz	-24445
4	Jon	10/16/2018		25
5	Dan	10/16/2018	Fz	40
Sheet1

what is the output that you want?

 

[MTS26]

Given this:

	A	B	C	D
2	Matt	10/12/2018	Time	0.028
3	Matt	10/12/2018	Fz	-24445
4	Jon	10/16/2018		25
5	Dan	10/16/2018	Fz	40

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

what is the output that you want?

I figured out the problem, I forgot to add a",0" following the last criteria. Thank you for the response