Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
454
Views
Topic starter
Hi!
I do manual work when creating reports with calculations, meaning I have reference table and then when I create report I link that reference in every 10th row. I assume this can be done smarter way, and I tried it with offset formula but just cannot figure out the syntax.
I have attached the example - in yellow cells I would like to figure out the formula for doing this and avoid this manual workaround.
Can someone please help me?
Thank you for ideas!
Maja
Posted : 09/02/2019 6:08 am
In B3:
=INDEX('Reference tale sheet'!B:B,4+INT((ROWS($A$1:$A1)-1)/9))
Copy to C3, then you can copy and paste your 9*2 blocks.
Posted : 09/02/2019 7:03 am
Topic starter
Thank you for help!
This does the trick 
Posted : 10/02/2019 12:32 pm
