• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Matching cell to different tab name

Brooksy1

New Member
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
 

p45cal

Well-Known Member
the CELL function has an optional argument being a cell on any sheet:
=MID(CELL("filename",Sheet4!A1),FIND("]",CELL("filename",Sheet4!A1))+1,255)
 
Top