Copying Index/Match Array to New Tab

[stlpony]

Hello,

I'm trying to best copy and paste an array formula to a new tab.

=INDEX(BackData!$A$1:$G$2155,MATCH(Rep1!$A$2&Rep1!A6,BackData!$D$1:$D$2155&BackData!$B$1:$B$2155,0),3) However, when I copy it the formula to the Tab for "Rep2", the formula stays with "Rep1". I want the formula to keep pulling from the same backdata tab ... Just change the tab from where the criteria is pulling. Any tips? Thanks!

<tbody>
</tbody>

 

[sheetspread]

You can change it with ctrl-h or delete the sheet name from the reference altogether.