Copying Index/Match Array to New Tab

[stlpony]

Hello,

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

[TABLE="width: 100"]
<tbody>[TR]
[TD="class: xl67, width: 100"]=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![/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

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