Incrementing a formula by 20 automatically

[Bowbender]

I've searched, but the answers didn't seem to match what I was looking
for.

I have two sheets.

On the sheet I'm pulling data into, I have the formula "=Results!B20"
sitting in cell "B14". This works fine, but I want to increment it to
"=Results!B40" in cell "B15" and so on. The Auto Fill handle doesn't
work for this and I have MANY cells I need to fill.

Any help is appreciated.

Thanks!

 

[Niek Otten]

=INDIRECT("results!b"&(ROW()-13)*20)

 

[Roger Govier]

Hi

An alternative non-volatile way
=INDEX(Results!$B:$B,ROW(A1)*20)

 

[Niek Otten]

Yes!

 

[muddan madhu]

this one

=INDIRECT("results!B"&20*ROW(A1))

or

=OFFSET(Results!B1,19*ROW(A1),)