N/A when copy and pasting INDEX formula to a new worksheet

[abrig005]

When I copy this formula: =INDEX($BM$3:$BY$7,MATCH($CA4,$BL$4:$BL$7, 0), MATCH(CC$3,$BM$2:$BY$2,0)) to a new worksheet I get an N/A.
I changed the external reference to sheetname! before each cell reference
Any idea?
Thank you!

 

[Asala42]

Are you getting "N/A" or the error "#N/A"?

If either of your MATCH functions don't find a precise match, the entire formula will output the #N/A. So you may want to confirm CA4 has a matching value in BL4:BL7 and CC3 has a matching value in BM2:BY2. Note that even 1 character difference, such as a leading or trailing space, could prevent a match.

 

[abrig005]

I am getting a #N/A error

Are you getting "N/A" or the error "#N/A"?

If either of your MATCH functions don't find a precise match, the entire formula will output the #N/A. So you may want to confirm CA4 has a matching value in BL4:BL7 and CC3 has a matching value in BM2:BY2. Note that even 1 character difference, such as a leading or trailing space, could prevent a match.

 

[Asala42]

That usually means one of your matches is not finding the lookup value.

 

[abrig005]

OK thanks, may be time from a break LOL!