Criteria in one column, but two rows

[rgillson3]

When we do our monthly inventory, there are some items that are tracked on a spreadsheet, and compare the totals to those of the previous month.

I'm trying to "simplify" it so I don't adjust as many formulas every month.

The items are in column E of Sheet1.

L5:S5 and T5:AA5 show categories of:

Total -Prior

Meat

Prod

Poultry

Groc

Seafood

Dairy

Bev

<tbody>
</tbody>

L1:S1 shows "CURR".

T1:AA1 shows "PREV".

I'd like to pull data from Sheet1 L5:S43.

I'm trying to match the following:

- E5:E43 on Sheet2 to each row in Sheet1
- T4:AA4 on Sheet2 to each column L5:S5 in Sheet1
- T1:AA1 on Sheet2 to each column L1:S1 in Sheet1

 

[rgillson3]

Does anyone have any recommendations for this?