Indexing & Double Matching Formula?

[Maverickballa]

Center	Jan 2017	Feb 2017	March 2017	April 2017
363	263	532	209	120
5032	120	111	123	678

<tbody>
</tbody>

Center	Date	Packages
363	Jan 2017	263
363	Feb 2017	532
363	March 2017	209
363	April 2017	120
5032	Jan 2017	120

<tbody>
</tbody>

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

Center	Jan-17	Feb-17	Mar-17	Apr-17
363	263	532	209	120
5032	120	111	123	678
Center	Date	Packages
363	Jan-17	263
363	Feb-17	532
363	Mar-17	209
363	Apr-17	120
5032	Jan-17	120

<tbody>
</tbody><colgroup><col span="2"><col><col span="2"></colgroup>

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