garymoore Unfortunately what you have ... =RIGHT('Sep 5'!X8:AF8,5) ... is an array formula. They cannot be entered in merged cells.
If you are not familiar with array formulas they are not like regular formulas. They must be committed from edit mode by simultaneously holding down Ctrl + Shift while hitting Enter. You can try this in a non merged cell to see it work.
Beyond that I can not tell what you are trying to achieve unless it is this.It does not have to be array entered.
Alternatively you might try unmerging 'Sep 5'!X8:AF8. The text "WORKS" only exists in 'Sep 5'!X8. There will be nothing but blanks in 'Sep 5'!Y8:AF8
Bookmarks