Absolute Reference in INDEX MATCH?

Hi,

PLEASE HELP!

In my spreadsheet I have the ID of the product I am searching for in column "A" and the Dates across row 7. there are thousands of dates and hundreds of products. I typed this formula to return a specific attribute (in array column #13) and it works in the first cell. but when I try to copy the formula across the next dates the formula updates MATCH(1,(Data!$A$2:$A$1557=A7) to MATCH(1,(Data!$A$2:$A$1557=B7). I tried to fix this with absolute refrence but I get a #N/A error.

{=INDEX(Data!$A$2:$M$1557,MATCH(1,(Data!$A$2:$A$1557=A7)*(Data!$E$2:$E$1557=C6),0),13)}

Does anyone know why i can't use absolute reference and if there is some way I can fix this?

ALSO POSTED AT https://www.mrexcel.com/forum/excel-...esnt-work.html