Pulling down a Formula discards a $

[Osprey3]

I am using the following formula to select every other column from a table
INDEX($H163:$AE163,MATCH(H$215&$C$210,$H$161:$AE$161 & $H$161:$ae$162,0))
My problem is that when I pull this down the column The final $ae$162 turns to $ae163 and thus all the way down.
The workbook that have attached to show this works as expected with no change to the "AE" part ($E$8:$J$8 in the attachment),but it does show what I want to achieve
I can't find a reason for the change and would be very grateful for some help
John

[davsth]

Its not helpful not seeing the sheet with the problem in it but

INDEX($H163:$AE163,MATCH(H$215&$C$210,$H$161:$AE$161 & $H$161:$ae$162,0)) is the red correct?

[Osprey3]

davsth,
Thanks for your interest. You have found a typo in my post. The code should read $H$162.
I have attached the whole offending sheet which still does show the error. Above each table you will see a line of code. I have a sub which copies this named range down to the table below. This is then copied and saved to itself as values
I found the fault though by copying and pasting manually.
You can see for yourself in colH rows216 and 217
John

[Glenn Kennedy]

H216, copied across and down:

=INDEX($H163:$AE163,,MATCH(1,($H$162:$AE$162=$C$210)*($H$161:$AE$161=H$215),0))