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!
I changed the external reference to sheetname! before each cell reference
Any idea?
Thank you!