hi -

I need some help building a formula, but not sure exactly how to
describe except to first describe my data layout:

Sheet A:
cell b1 - user-selected week (by validation)
cell b2 - user-selected category (by validation)
cells A5:A25 - store numbers
cells B5:B25 - where the formula will go

Sheet B:
cells D5:BD5 - week
cells A6:A? - store numbers (range will vary)
cells B6:B? - categories
* there are approx 40 Categories for each store

So, the formulas in SheetA, B5:B25 should pull data from the
intersection of week & Store-Category ...

Can anyone help?

Thx, ray