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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Matt
[/TD]
[TD]10/12/18[/TD]
[TD]Time[/TD]
[TD].028[/TD]
[/TR]
[TR]
[TD]Matt[/TD]
[TD]10/12/18[/TD]
[TD]Fz[/TD]
[TD]-24445[/TD]
[/TR]
</tbody>[/TABLE]

 

[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
Matt	Time
Matt	Fz
Jon
Dan	Fz

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]2[/TD]

[TD="align: right"]10/12/2018[/TD]

[TD="align: right"]0.028[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]10/12/2018[/TD]

[TD="align: right"]-24445[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]10/16/2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]10/16/2018[/TD]

[TD="align: right"]40[/TD]

</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