CODEWITHSUNDEEP
excel
Tayyab
Tayyab

Reputation: 39

Excel Formula to show value in a specific cell after same interval

enter image description here

I am trying to show the value of B4 to D33 and when I drag it down it shows the value of B13 to D34 and so on with the same interval and pattern. I found a help article with the OFFSET function, tried it but it seems to be not working in my case. Any suggestion?

Regards

Upvotes: 1

Views: 663

Answers (1)

Foxfire And Burns And Burns
Foxfire And Burns And Burns

Reputation: 11988

A tricky one. It looks like you want to get Week1 value from datasets 1, 2 or 3, depending of which row.

References in Excel do not work the way you want. When draging fórmulas they will always increase reference by 1 column or 1 row. So you need to be tricky here.

One approach would be this:

enter image description here

My formula in cell D33 is:

=VLOOKUP($A$30;CHOOSE(MID(A33;5;99);$A$4:$B$8;$A$13:$B$17;$A$22:$B$26);2;FALSE)

Upvotes: 2

Related Questions