+ Reply to Thread
Results 1 to 6 of 6

Need to look up a value and return multiple values-INDEX/MATCH?

  1. #1
    Registered User
    Join Date
    08-09-2012
    Location
    Washington, DC
    MS-Off Ver
    Excel 2010
    Posts
    10

    Need to look up a value and return multiple values-INDEX/MATCH?

    Hi all, I have been searching to answer to this specific issue, and I see a lot about the INDEX and MATCH functions. I can't seem to figure out how to adapt the info I've read in other posts to my situation.

    I have two worksheets. The first, named TITLES, has an ID# and a title. The second, named AKAs, has an ID# and and AKA TITLE. I want to look up the ID# from TITLES and return the multiple values from AKAs. The desired result could be whichever of the 3 examples is easier- repeating the TITLE for each AKA TITLE, or grouping the AKA TITLES under one TITLE, or concatenating the AKA TITLES into one cell.

    Any assistance would be greatly appreciated. Thank you!!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-27-2012
    Location
    London, England
    MS-Off Ver
    2003, 2010
    Posts
    344

    Re: Need to look up a value and return multiple values-INDEX/MATCH?

    Hi - If you use the below in cell C2 of AKA TITLES sheet, does it work for you?

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You can then sort on ID#.
    If solved kindly remember to mark Thread as solved.
    Click the small star icon at the bottom left of my post if this was useful.

  3. #3
    Registered User
    Join Date
    10-27-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Need to look up a value and return multiple values-INDEX/MATCH?

    I am also facing the same problem, can anyone tell me how can I get the Desired Result Option 3 (as attached sheet of abigail99)

    Thx

  4. #4
    Registered User
    Join Date
    08-09-2012
    Location
    Washington, DC
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Need to look up a value and return multiple values-INDEX/MATCH?

    Quote Originally Posted by kbkumar View Post
    Hi - If you use the below in cell C2 of AKA TITLES sheet, does it work for you?

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You can then sort on ID#.
    kbkumar, thanks for taking a look. The problem is that your solution gives me the TITLES to match the AKA TITLES. I need the other way around. The AKA TITLES list is going to have many thousands of rows and be fairly static, and each week I'm going to get a new list of 100 or so TITLES, which need to be matched with AKA TITLES.

  5. #5
    Forum Contributor
    Join Date
    09-27-2012
    Location
    London, England
    MS-Off Ver
    2003, 2010
    Posts
    344

    Re: Need to look up a value and return multiple values-INDEX/MATCH?

    Understand...is your organization of data static or there is any scope for reorganization?

  6. #6
    Registered User
    Join Date
    10-27-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Need to look up a value and return multiple values-INDEX/MATCH?

    static data

+ 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