Hi, guys!
I have the following issue to solve:
I'd like to have a dynamic "reference" step for OFFSET function - unfortunately when I put vlookup there, the formula doesn't want to work.

Here you are examples:
1. =SUM(OFFSET(Actual!D125,0,0,1,$D$1),VLOOKUP($D12,Actual!$C$6:$O$597,2)) - this is working, as you can see the underlined references gives to the OFFSET the cell as reference

but when i try to make it dynamic...

2. =SUM(OFFSET(VLOOKUP($D12,Actual!$C$6:$D$597,2,0),0,0,1,$D$1),VLOOKUP($D12,Actual!$C$6:$O$597,2)) - here I replaced the single cell reference from previous example with the underlined one here and formula is not working.

Please, help me on this thing...