need help using the offset function differently
 

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

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

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

"UBER_GEEK" wrote:

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