+ Reply to Thread
Results 1 to 6 of 6

Naming the tab a reference cell is on.

  1. #1
    Registered User
    Join Date
    03-18-2021
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2016
    Posts
    3

    Naming the tab a reference cell is on.

    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!

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Naming the tab a reference cell is on.

    Hey,
    Do you have a sample to share?

  3. #3
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Naming the tab a reference cell is on.

    I Had an idea to list the tab names in your summary sheet like I did in the attached , list the requested value in column A
    and use this formula in B2 and across:
    IFERROR(VLOOKUP($A2,INDIRECT("'"&B1&"'!$A:$A"),1,0),"")

    the value found will appear under the matching tab name.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-18-2021
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2016
    Posts
    3

    Re: Naming the tab a reference cell is on.

    Hi Belinda.

    I have mocked up a very basic example of how my spreadsheet is laid out.
    I was hoping to get a the name of the actual tab the unique reference is on as a text answer?
    Hopefully the spreadsheet attached as I have been having issues with the website tonight. Thanks
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Naming the tab a reference cell is on.

    OK, so the values are not unique in your example, but assuming it's a mistake - you can add tab names as titles in columns E-G like I did in the attached,
    and use this formula to return blank or value name under the corresponding tab name

    =IFERROR(VLOOKUP($B4,INDIRECT("'"&E$3&"'!$A:$A"),1,0),"")

    Then in C:
    =INDEX(E$3:G$3,,MATCH(1,1/(E4:G4<>"")))
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-18-2021
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2016
    Posts
    3

    Re: Naming the tab a reference cell is on.

    Thank you for your help. I will try to apply this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Save excel file as pdf with cell reference to date/time for naming
    By sdjohnson620 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2016, 08:12 PM
  2. [SOLVED] Prevent Errors for Duplicate Tab Names When Naming Tabs Using Cell Reference
    By DeRo22 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-04-2014, 03:26 AM
  3. [SOLVED] Reference a worksheet without naming
    By Tortus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-20-2014, 04:51 PM
  4. Adding ROW using 1 column as reference and another column for naming - BAD title
    By dbondmelo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-21-2013, 12:05 PM
  5. Reference cell in different sheet by naming the sheet in seperate cell
    By johnnyboyisme in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2013, 03:43 AM
  6. Folder naming + File naming
    By Frozt15 in forum Excel General
    Replies: 2
    Last Post: 07-23-2012, 04:52 AM
  7. naming a column & naming a cell with a number
    By evanzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2008, 10:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1