Formula on cell reference

[Valoucette]

I'm posting my question in this programming section as it possibly requires a macro.

I would like to insert in a colum the values of another column, taking one value every 11 raws. For example:
B1=C4
B2=C15
B3=C26
B4=C37
Etc...

When I drag the 4 cells down, I obtain:
B5=C8
B6=C19
B7=C30
B8=C41

If I drag down the last 3 ones, I obtain:
B5=C18
B6=C29
B7=C40

Do you know how it works and how I could get
B5=C48
B6=C59
B7=C70
Etc...?


I've tried with a concatenate
=concatenate("=C"&"D1)
Where I have
D1=4
D2=15
D3=26
Unfortunatelly the result of "concatenate" is a string (text), so it doesn't calculate it.

Thanks,
Valerie

[StephenR]

Try this:

=OFFSET($C$1,11*(ROW()-1)+3,0,1,1)

[Valoucette]

Thanks for the principle! It helps me to do what I wanted.