How to create an offset column

[Silvex]

Hello,

For an N group of ID´s I need to test the expected behavior. I managed to do this in Excel using, in the Expected ID column, the Offset formula that is =OFFSET(B2,C2,0).

Group	Given ID	Offset	Expected ID	Result
Group 1	A	0	A	OK
Group 1	A	-1	A	OK
Group 1	B	0	B	OK
Group 1	A	-3	A	OK

I tried to do this using the multi-row formula however I have to enter a specific number or rows which in my case is dynamic. I´ve attached an Excel spread sheet with an example. The column I need to create is the Expected ID column.

Any help will be appreciated.

Thanks!

[Silvex]

Thank you so much! I really appreciate the help! It worked! :)