Indexing & Double Matching Formula?

[Maverickballa]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Center[/TD]
[TD]Jan 2017[/TD]
[TD]Feb 2017[/TD]
[TD]March 2017[/TD]
[TD]April 2017[/TD]
[/TR]
[TR]
[TD]363
[/TD]
[TD]263[/TD]
[TD]532[/TD]
[TD]209[/TD]
[TD]120[/TD]
[/TR]
[TR]
[TD]5032[/TD]
[TD]120[/TD]
[TD]111[/TD]
[TD]123[/TD]
[TD]678[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Center[/TD]
[TD]Date
[/TD]
[TD]Packages[/TD]
[/TR]
[TR]
[TD]363[/TD]
[TD]Jan 2017[/TD]
[TD]263[/TD]
[/TR]
[TR]
[TD]363[/TD]
[TD]Feb 2017[/TD]
[TD]532[/TD]
[/TR]
[TR]
[TD]363[/TD]
[TD]March 2017[/TD]
[TD]209[/TD]
[/TR]
[TR]
[TD]363[/TD]
[TD]April 2017[/TD]
[TD]120[/TD]
[/TR]
[TR]
[TD]5032[/TD]
[TD]Jan 2017[/TD]
[TD]120[/TD]
[/TR]
</tbody>[/TABLE]

The top table is how I currently have my data.

I want to have the data running vertical and a formula to be able to match the center number & appropriate date to get the right amount of packages.

This formula would apply to 5 excel tabs all with the same layout.

Any help would be greatly appreciated!

Scottie

 

[texasalynn]

try this
[TABLE="width: 330"]
<tbody>[TR]
[TD]Center[/TD]
[TD]Jan-17[/TD]
[TD]Feb-17[/TD]
[TD]Mar-17[/TD]
[TD]Apr-17[/TD]
[/TR]
[TR]
[TD]363[/TD]
[TD]263[/TD]
[TD]532[/TD]
[TD]209[/TD]
[TD]120[/TD]
[/TR]
[TR]
[TD]5032[/TD]
[TD]120[/TD]
[TD]111[/TD]
[TD]123[/TD]
[TD]678[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Center[/TD]
[TD]Date[/TD]
[TD]Packages[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]363[/TD]
[TD]Jan-17[/TD]
[TD="align: right"]263[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]363[/TD]
[TD]Feb-17[/TD]
[TD="align: right"]532[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]363[/TD]
[TD]Mar-17[/TD]
[TD="align: right"]209[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]363[/TD]
[TD]Apr-17[/TD]
[TD="align: right"]120[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5032[/TD]
[TD]Jan-17[/TD]
[TD="align: right"]120[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col span="2"><col><col span="2"></colgroup>[/TABLE]

formula used: =HLOOKUP(B7,$B$1:$E$3,MATCH(A7,$A$1:$A$3,0),0)