Is there a function/formula that I could use that would tell me which tab a certain cell is on.
For my job I have to juggle multiple unique references (normally text) that I was hoping to track them across people in my team. They each have their own tab on the spreadsheet and the unique references are never duplicated across people .
For example, I would like to put the unique reference into a cell on a summary tab, and the next cell along would tell me which tab that unique reference is on.
Any help would be very much appreciated!
Bookmarks