Copying data from one sheet to another, formula doesn't work

[RodneyC]

I'm copying two sheets from one doc to another. The first sheet is named "Naming". I have copy/pasted it exactly as it is and named it "Naming"

The second sheet is copied exactly as it is from the original source. On this second sheet this code is in cell D28

=INDEX(Naming!$C$4:$C$551,MATCH(1,($D$3=Naming!$A$4:$A$551)*($B27=Naming!$B$4:$B$551),0))

When I copy/paste the second sheet into the new doc, the code in cell D28 changes to this:
=INDEX('[Digital Metrics Sep21 2021-10-14.xlsx]Naming'!$C$4:$C$551,MATCH(1,($D$3='[Digital Metrics Sep21 2021-10-14.xlsx]Naming'!$A$4:$A$551)*($B27='[Digital Metrics Sep21 2021-10-14.xlsx]Naming'!$B$4:$B$551),0))

The data displays correctly but I don't want it to reference the other doc, I need it to be fully self contained in the second doc. When I change the code on the second doc, cell D28 to the original code:

=INDEX(Naming!$C$4:$C$551,MATCH(1,($D$3=Naming!$A$4:$A$551)*($B27=Naming!$B$4:$B$551),0))

I'm get a #N/A error. I've confirmed all columns and rows are the same on both sheets in both docs.

Any ideas?

Thanks on advance

 

[mackc557]

Should it be:
=INDEX('Naming'!$C$4:$C$551,MATCH(1,($D$3='Naming'!$A$4:$A$551)*($B27='Naming'!$B$4:$B$551),0))

 

[RodneyC]

Thanks for your reply but that also produces #N/A