Hello-

I have 2 different sheets in a workbook; one contains stock values since the beginning of 2011 of a particular ETF. I'm trying to look at the performance of an ETF picking service that releases suggested ETFS each week. Therefore, I'm looking pull the high value of every 5th row. For example, the formula I'm inputting is:

=IVV!C41
=IVV!C46
=IVV!C51

However, whenever I try to auto-complete (drag and drop the corner), of these three highlighted values, excel grabs the value of a lower number, not picking up on the 'every 5' pattern.

How can I fix this?

Thanks