Looking up the tab name from a cell

D

D Fullman

I need a function which will allow a cell to look up the
name of the tab (ie on the same sheet).

Any ideas?
 
B

Bob Phillips

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
IOS App: Contacts in search or in new mail not found 0
Consolidation Table from Different Excel Tabs with Different Format 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Newbie Help - IF Yes No Function 0
Excel - Wich Function should I use? 1
ASK Field Formatting 1
How do I link a cell in a workbook? 1

Top