Multiple Index Match Assistance

[OriginalCarey]

Hi guys

[TABLE="width: 500"]
<tbody>[TR]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]817[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]25/04/2017[/TD]
[TD]02/05/2017[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I have a set of Data on a sheet called "data", and the above table on a sheet called "Checks". The Dates are dynamic, and will change per users selection.

I need to gather the figure from 817 on "data" sheet which also matches the Date, I have used vlookup previously but this was when the Date's were static, however, now they're changing, and the "data" sheet is ever growing.

The data sheet looks like:

[TABLE="width: 500"]
<tbody>[TR]
[TD]TestID[/TD]
[TD]Description[/TD]
[TD]24/04/2017[/TD]
[TD]02/05/2017[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]xxx[/TD]
[TD]45[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]770[/TD]
[TD]xxx[/TD]
[TD]46[/TD]
[TD]45[/TD]
[/TR]
[TR]
[TD]817[/TD]
[TD]xxx[/TD]
[TD]234[/TD]
[TD]123[/TD]
[/TR]
</tbody>[/TABLE]

Can anyone assist with the formula for this? I couldnt figure out Index MATCH MATCH

Cheers

 

[AlanY]

like this?

Excel 2013/2016
	A	B	C	D	E	F	G	H
1	TestID	Description	24/04/2017	02/05/2017		817	234	123
2	40	xxx	45	23			24/04/2017	02/05/2017
3	770	xxx	46	45
4	817	xxx	234	123
Sheet4

Cell Formulas
Range	Formula
G1	=INDEX($A:$D,MATCH($F$1,$A:$A,0),MATCH(G$2,$A$1:$D$1,0))

 

[OriginalCarey]

like this?

Excel 2013/2016

	A	B	C	D	E	F	G	H
TestID	Description
xxx
xxx
xxx

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

[TD="align: right"]24/04/2017[/TD]
[TD="align: right"]02/05/2017[/TD]
[TD="align: right"][/TD]
[TD="align: right"]817[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"]234[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"]123[/TD]

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

[TD="align: right"]45[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]24/04/2017[/TD]
[TD="align: right"]02/05/2017[/TD]

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

[TD="align: right"]46[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

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

[TD="align: right"]234[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet4​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G1[/TH]
[TD="align: left"]=INDEX($A:$D,MATCH($F$1,$A:$A,0),MATCH(G$2,$A$1:$D$1,0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Was just coming on to say I've managed to figure it out!

Here is my forumla I used:

=INDEX(data!$C$2:$Q$21,MATCH(Checks!$B$2,data!$A$2:$A$21,0),MATCH(Checks!C3,data!$C$1:$Q$1,0))

 

[wideboydixon]

Not 100% sure how your sheets are laid out and where you want the results but it's something like this:

Book1
	A	B	C	D
1	TestID	Description	25/04/2017	02/05/2017
2	40	xxx	45	23
3	770	xxx	46	45
4	817	xxx	234	123
data

Book1
	B	C	D
1	817
2		25/04/2017	02/05/2017
3		234	123
Checks

Cell Formulas
Range	Formula
C3	=INDEX(data!$A:$D,MATCH($B$1,data!$A:$A,0),MATCH(C$2,data!$1:$1,0))
D3	=INDEX(data!$A:$D,MATCH($B$1,data!$A:$A,0),MATCH(D$2,data!$1:$1,0))

WBD