Index/Match calc to address 3 criteria in multiple rows and columns using 1 ref table

[1latenite]

[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]SKU#
[/TD]
[TD]2301
[/TD]
[TD]2301
[/TD]
[TD]2301
[/TD]
[TD]50010
[/TD]
[TD]5000
[/TD]
[TD]50010
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]$
[/TD]
[TD]Units
[/TD]
[TD]Stores
[/TD]
[TD]$
[/TD]
[TD]Units
[/TD]
[TD]Stores
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]23
[/TD]
[TD]3
[/TD]
[TD]50
[/TD]
[TD]15
[/TD]
[TD]2
[/TD]
[TD]48
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]6.99
[/TD]
[TD]1
[/TD]
[TD]50
[/TD]
[TD]17
[/TD]
[TD]2
[/TD]
[TD]48
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]30
[/TD]
[TD]6
[/TD]
[TD]50
[/TD]
[TD]6
[/TD]
[TD]1
[/TD]
[TD]48
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]50
[/TD]
[TD]15
[/TD]
[TD]2
[/TD]
[TD]48
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]100
[/TD]
[TD]20
[/TD]
[TD]50
[/TD]
[TD]15
[/TD]
[TD]2
[/TD]
[TD]48
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]72.32
[/TD]
[TD]15
[/TD]
[TD]50
[/TD]
[TD]7
[/TD]
[TD]1
[/TD]
[TD]48
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]6.99
[/TD]
[TD]1
[/TD]
[TD]50
[/TD]
[TD]18
[/TD]
[TD]2
[/TD]
[TD]48
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]28.57
[/TD]
[TD]4
[/TD]
[TD]50
[/TD]
[TD]6
[/TD]
[TD]1
[/TD]
[TD]48
[/TD]
[/TR]
</tbody>[/TABLE]


















Hi all -

I'm usually fairly savvy with index matching, but struggling with this due to the criterion I have running different directions in a pivot style data source (SKU # and Metric Type are in the top 2 rows, Sales WK is the first column, data flowing in correspondence across the the rows and columns).


The data is a bit repetitive and my summary page displays each metric chronologically (Weeks are running 1 -52 across the top, and the SKU numbers are running down the first column). On summary sheet recaps $, one sheet recaps Units sold and the last recaps store count.

Anyone have a recommendation on the best way to grab the data and get it re-toggled? Its a large amount.... over 350 SKUs in the source file.

Much appreciated!

---