Morning all,
I have found the bellow formula on another site which works great at matching a cells contents to the name of the tab that cell is in however I wonder if there is a way to alter it so the cell contents matches the name of a different tab within the same workbook? VBA is not an option as the workbook is shared and worked on both with the desktop app and online version of excel.
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
Any support would be amazing.
Tom
I have found the bellow formula on another site which works great at matching a cells contents to the name of the tab that cell is in however I wonder if there is a way to alter it so the cell contents matches the name of a different tab within the same workbook? VBA is not an option as the workbook is shared and worked on both with the desktop app and online version of excel.
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
Any support would be amazing.
Tom