need help using the offset function differently

[Marshin]

I would like to use the offset offset based on the cell referanced from the
answer of another cell.

 

[UBER_GEEK]

really need an example, but sounds like the indirect function could
possibly help.

 

[Marshin]

I am working with large sheets of data but I will brake it down to just a few
cells

I already have a function that can recognize the end of one set of data and
start the next set but that is where I run into this problem, see example

data 1 data2 result
1 a 1
2 b 2
3 c 3
4 d 4
a
b
c
d

the data size is not alway the same, so the function needs to be some what
dynamic