simple formula I'm sure using offset? or index?



In cell b1 i have a named range "month". I want to be able to change the
value of month and have the cooresponding values appear in b2-b6. What I'm
after here is the formula I put in b2-b6. Thanks.

a b c d e f
1 Product jan jan feb mar apr
2 prod-a 100 100 200 300 400
3 prod-b 125 125 225 350 450
4 prod-c 175 175 210 325 400
5 prod-d 190 190 220 350 325
6 prod-e 150 150 235 375 390


Put this in B2:


then copy down.

Hope this helps.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question