+ Reply to Thread
Results 1 to 3 of 3

Formula that references different tabs according to a data validation field?

  1. #1
    Registered User
    Join Date
    10-08-2009
    Location
    Calgary Canada
    MS-Off Ver
    Excel 2010
    Posts
    20

    Formula that references different tabs according to a data validation field?

    This is something i've always had in mind but never had much of a reason to put a lot of time into it until today, and now i'm stuck. What i'm looking to do is write a formula to reference other worksheets (basically to work with anything, sumifs, vlookup, if formulas, etc etc) that changes according to whats selected from a data validation drop down box. I've attached a spreadsheet that elaborates a little further. Is this a possibility without having to dive into VBA?

    There's 53 worksheets for the spreadsheet i'm working with and the only thing i can think of is having a very lengthy =if formula that relates to every tab. But if there's an easier way, i'd love to know!


    *Edit- SOLVED. =INDIRECT formula did the trick.
    Attached Files Attached Files
    Last edited by Rizzu; 12-27-2012 at 06:28 PM.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Formula that references different tabs according to a data validation field?

    Try

    =SUM(INDIRECT(B2&"!A:A"))

  3. #3
    Registered User
    Join Date
    10-08-2009
    Location
    Calgary Canada
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Formula that references different tabs according to a data validation field?

    Awesome thank you! That did the trick.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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