To do this in way you described is possible only when you write your own UDF, like described here: vba - find cell reference of a cell from another cell in excel - Stack Overflow

To do this using built-in Excel formulas only, you have to enter row number(s) for start cell(s) somewhere, and use them to refer to wanted start cells. In added example is shown how to do this. Starting row numbers of worksheet are entered into Named Range nTimeRows.

This design isn't fully dynamic jet, as start row numbers are for worksheet rows. Whenever you add/remove rows above Tables tBPM and tDistr, you have to update row numbers in nTimeRows manually.

To make design fully dynamic, you have to store in nTimeRows row numbers of Table tBPM instead of worksheet row numbers. This of-course means, you have to change the formula in Table tDistr accordingly.

Attached Files

Example_Offset.xlsx (15.1 KB, 11 views)