+ Reply to Thread
Results 1 to 4 of 4

How to get corresponding information to show when choosing from drop down list.

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    Mississippi
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to get corresponding information to show when choosing from drop down list.

    Hello. I need help on learning how to get corresponding information to show when choosing from drop down list.
    On the first sheet I have an area where I put I list of teams with their information. Part of the information I would like to have for each team is an option to choose a player on the team from a drop down list and based on who I choose from the list, their information should appear next to their name. I already have the drop down list developed in the sheet. How can I get the information from sheet 2 (called team players,handicaps) to appear in sheet 1 (called team and sponsor info) when choosing from the drop down list.

    I have attached the excel file to this message to show you what I mean. The drop down list is on sheet 1 H3 and I would like the information for each player (handicap and phone number) from sheet 2 to pop up next to the players name on sheet 1.

    SilverTee Team and Sponsor Info.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: How to get corresponding information to show when choosing from drop down list.

    You can use this for J3 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    And if you on your second sheet didn't merge cells, and just adjusted the column width to match the data, and deleted superflous columns, then you can also copy across.
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  3. #3
    Registered User
    Join Date
    08-21-2012
    Location
    Mississippi
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to get corresponding information to show when choosing from drop down list.

    Thank you very much! Also, if you have time, could you explain the steps you took to get that formula to work properly? I would like to know for future purposes.

  4. #4
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: How to get corresponding information to show when choosing from drop down list.

    you're welcome!

    The problem with merged cells is that when writing formulas and using the cursor to select the arrays to include in them, then your arrays tend to expand beyond what you want. E.g. in your workbook, if I remember correctly, trying to select F3:F21 ends up giving you F3:G21, which causes the formula to error out. Instead you have to "write" your references using your keyboard.

    Is that what you were asking for, or was it more general information on =INDEX(MATCH()) you were looking for? In that case this:
    http://www.contextures.com/xlFunctio...tml#IndexMatch
    explains it better than I can in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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