• 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


  • 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


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.


Any support would be amazing.



Well-Known Member
the CELL function has an optional argument being a cell on any sheet: