+ Reply to Thread
Results 1 to 4 of 4

Dynamic Range based on Data Validation

  1. #1
    Registered User
    Join Date
    01-15-2010
    Location
    Scottsdale
    MS-Off Ver
    Excel 2010
    Posts
    72

    Dynamic Range based on Data Validation

    I have 12 different named rages for coresponding months. I also have a Data Valadation Cell with a list (the 12 months). Is there a way to call on a name range based on what is in the Month cell?

    For example if I wanted to do a sumif formula:
    sumif(range, Criteria, *this is where I would like to reference a cell that has the name of my named range*)

    My goal is to be able to change the sumif sum range when I change the month from the drop down list.

    Is it possible?
    Last edited by Dial1; 01-15-2010 at 01:25 PM.

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Is there a way.... (Named Ranges)

    Something like Indirect(C1), where C1 has the name of the named range will work in your formula.

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Is there a way.... (Named Ranges)

    dial1,

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    on this occasion I have modified for you - going forward please endeavour to follow the above guidelines.

  4. #4
    Registered User
    Join Date
    01-15-2010
    Location
    Scottsdale
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Is there a way.... (Named Ranges)

    Quote Originally Posted by DonkeyOte View Post
    dial1,

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    on this occasion I have modified for you - going forward please endeavour to follow the above guidelines.

    My apologies and thank you for the Title.

+ 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