INDEX/MATCH Across multiple columns

[Headline31]

Hello,

I am having some issues with a complex INDEX/MATCH formula but am not sure if this is even possible. I am trying to pull numbers from a large array based on 3 criteria. There are 2 tables below; the left is the manual entry data tab, and the right is a more simplistic view where the Name, Label and Date can all be changed. I am looking to get the data from Jan1-Jan31 based on 3 criteria. First, as an example, I need the Name to find name1 (all the same name). Then, Label to find label2. And finally, Date to find Jan2. Is it even possible to have the criteria spread the way it is (in rows and columns)?


[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Jan1
[/TD]
[TD]Jan2
[/TD]
[TD]Jan3
[/TD]
[TD]Jan4
[/TD]
[TD]Jan5
[/TD]
[/TR]
[TR]
[TD]name1
[/TD]
[TD]label1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name1
[/TD]
[TD]label2
[/TD]
[TD][/TD]
[TD]XXX
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name1
[/TD]
[TD]label3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name1
[/TD]
[TD]label4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 300, align: right"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Date
[/TD]
[/TR]
[TR]
[TD]Name
[/TD]
[TD]Label
[/TD]
[TD]FORMULA
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

Is this what you want?

Excel 2010
	A	B	C	D	E	F	G	H
1			1-Jan	2-Jan	3-Jan	4-Jan	5-Jan
2	name1	label1
3	name1	label2		XXX
4	name1	label3
5	name1	label4
6
7
8
9
10
11				2-Jan
12		name1	label2	XXX
Sheet6

Cell Formulas
Range	Formula
D12	{=INDEX(C2:G5,MATCH(B12&C12,A2:A5&B2:B5,0),MATCH(D11,C1:G1,0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Headline31]

That worked perfectly! Such an easy fix but I appreciate the help!