So I am stuck here trying to change the last part of a formula across 365 rows to an absolute formula.

=INDEX(Sheet5!$B$3:$NC$30000,(MATCH('Sheet6 (2)'!B2,Sheet5!$A:$A,0)-2),'Sheet6 (2)'!**I1**)

I need the very end, 'I1' to go to '$I$1' and the next column is;

=INDEX(Sheet5!$B$3:$NC$30000,(MATCH('Sheet6 (2)'!B2,Sheet5!$A:$A,0)-2),'Sheet6 (2)'!**J1**)

So 'J1' needs to change to '$J$1' and so on for each column (365).

Ctrl+find&replace will not work since the cell reference in each column is different and dragging across the row will not work either. Any suggestions?