Offset based on cell value

[Snackan1986]

Hi,

How can I offset rows based on other cells value.

Let´s say cell value of cell B2 = 2


In cell B10: = Offset(B10, B2, 0)


In this case it should be offset with 2 rows based on cell B2 value. I can probably solve it through a function in VBA but how can I solve it without VBA?


Thanks

 

[Aladin Akyurek]

If B2 = 2, what are you hoping with OFFSET to get?

 

[r1998]

Hello
use this

=OFFSET(B10, INDIRECT("B2"), 0)