+ Reply to Thread
Results 1 to 6 of 6

Drop Down Menu changes changes multiple cell values

  1. #1
    Registered User
    Join Date
    02-26-2012
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2010
    Posts
    62

    Drop Down Menu changes changes multiple cell values

    DROP DOWN QUESTION.xlsx If you take a look at the attached file, is there a way I can get A1 to be a drop down menu that holds 1, 2, 3, 4 in it? When 1 is picked cells (A2:A4) show the values of the 3 cells directly under the 1 column (i.e. .3, .2, .8 in cells A2, A3 and A4 respectively). The same goes for when 2, 3 or 4 or picked from the drop down.
    Last edited by dompoma; 05-08-2013 at 08:33 PM.

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Drop Down Menu changes changes multiple cell values

    Quote Originally Posted by dompoma View Post
    If you take a look at the attached file...
    I don't see an attached file?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    02-26-2012
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: Drop Down Menu changes changes multiple cell values

    Oops, it should be attached now. Thanks for letting me know

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Drop Down Menu changes changes multiple cell values

    OK, try this...

    Setup the drop down list

    Select cell A2
    Goto the Data tab>Data Tools group>Data Validation
    Allow: List
    Source: =$C$1:$F$1
    OK out

    Enter this formula in A2 and copy down to A4:

    =IFERROR(INDEX(C$2:F$4,ROWS(A$2:A2),MATCH(A$1,C$1:F$1,0)),"")

  5. #5
    Forum Contributor
    Join Date
    05-07-2013
    Location
    apple valley ca
    MS-Off Ver
    Excel 2007
    Posts
    110

    Re: Drop Down Menu changes changes multiple cell values

    try this.. they have drop downs and it returns what you want..
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-26-2012
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: Drop Down Menu changes changes multiple cell values

    thanks xwarlock10x! it works perfectly.

+ 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