+ Reply to Thread
Results 1 to 2 of 2

Drop Down Lists and linking them with other data

  1. #1
    Registered User
    Join Date
    08-12-2009
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    1

    Drop Down Lists and linking them with other data

    First time here. I know how to create drop down lists, but I can't seem to link the other cells with other day based on the choice you make. For example you have a drop down list with items. You select an item on the list, and depending on the items it will pull up statistics that match that current item (the stats are somewhere else on the workbook).

    Another example is if you have a list with item A, B, and C. You create a drop down list for it. When you select item A the statistics of type, cost, weight, all show up in the other cells. However if you select B, the statistics of B will show up. The type of statistics are all the same for all items, but the values are all different. So how does one match a value of multiple stats (each stat has a different cell), based on the item you select on the drop down list?

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

    Re: Drop Down Lists and linking them with other data

    This would involve the use of a Vlookup() formula...

    e.g

    =Vlookup($A1,$W$1:$Z$100,Columns($A$1:B$1),False)

    where A1 contains the drop down list and W1:Z100 contains the table to extract from (Column W containing the same values as the drop down list)... The Columns($A$1:B$1) converts to a number representing the column number within the table to extract from.. first being column 2 (or column X)...

    adjust as necessary to accomodate your sheets...

    Copy the formula across 4 columns... and down if desired
    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.

+ 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