+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : how to get a drop down menu choice to change adjacent cells

Hybrid View

  1. #1
    Registered User
    Join Date
    04-27-2012
    Location
    Kingston, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    6

    how to get a drop down menu choice to change adjacent cells

    I am creating a price list that contains multiple items in different combinations, for example I have multiple parts that can be sold separately or in a system.

    I would like to have a section in the price list that combines a number of parts to create a complete system and get the final price. I have been able to create lists using data validation and name Manager but after that I get lost.

    Example:
    A26 contains a list of 4 options which are located in A6:A9. A6 is the product name, b6 is the product code, c6 is the MSRP etc... all the way to H6. What I would like is that when A6 is selected from this drop down menu in A26 I would like the adjacent cells to the right of A26 to automatically be filled in with the contents from A6 through H6 so that when I am making a customized system I can chose the products I need and have the prices imputed automatically instead of adding them all up separately.

    I have attached a sample price list with what I am trying to accomplish. My understanding of excel formulas is pretty basic so please don't take anything for granted when explaining.

    Help is very much appreciated and look forward to hearing some suggestions.

    Thank you very much.
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: how to get a drop down menu choice to change adjacent cells

    In B25 enter:

    =IF($A25="","",INDEX(B$1:B$22,MATCH($A25,$A$1:$A$22,0)))

    copied down to B27 and across the columns
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    04-27-2012
    Location
    Kingston, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: how to get a drop down menu choice to change adjacent cells

    It worked like a charm and I have been able to adjust it slightly to work in other pages. Thank you very much for your precise and speedy response. I will look up on my own what all the symbols mean to try and reverse engineer that formula so I understand where it came from. Thanks again.

+ 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