Drag formula but skip 27 rows

[rhudgins]

In B4 I reference cell B59. In B5 I would like to reference B86.

What formula can I put in B4 that I can drag down to B5 and skip 27 reference cells?

[shg]

In B4, =INDEX(B:B, (ROWS(B$4:B4)-1)*27 + 59)

That can be modified depending on how you want the behavior to change as a result of inserting rows above.

[rhudgins]

Thanks. If there are no matching values the formula returns "0". How can I change it to return blank

[shg]

There's no match of any kind in the formula.