+ Reply to Thread
Results 1 to 4 of 4

Vlookup with multiple returns

  1. #1
    Registered User
    Join Date
    11-08-2012
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2010
    Posts
    16

    Vlookup with multiple returns

    Hello,

    I'm trying to figure out a way to use Vlookup to bring back multiple values for specific terms. Here is a sample of what my reference table looks like:

    Col. A Col. B
    Magi1 15
    Magi1 9
    Magi1 12
    Magi1 13
    Hspx9 4
    Hspx9 2
    Rrbm16 23
    Rrbm16 31
    Rrbm16 17

    So I I'm trying to find the values in Column A, for example Magi1, and then use my formula to return each value corresponding to Magi1, which here would be 15, 9, 12, and 13. I don't want to sum these Column B values or anything. I just want to see all the Column B values that each correspond to a specific value in Column A.

    Thank-you

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Vlookup with multiple returns

    Hi Erik,

    Try using below formula:-

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


    Enter this using ctrl shift enter key combination.

    See attached:- multiple lookup values.xlsx


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Vlookup with multiple returns

    a vlookup will only return the very 1st match it find. so unless you can find some1 to add something to the values in A to make the duplicates unique, then I would suggest that you maybe take a look at using filters?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Vlookup with multiple returns

    It’s not possible to get the matching data with concatenated result using a single cell worksheet function. So try the below UDF

    Please Login or Register  to view this content.
    =CLookup(LookupValue,LookupRange,ResultRange)

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

    Drag it down.

    Refer the attached excel for details.
    Attached Files Attached Files
    Last edited by :) Sixthsense :); 11-22-2012 at 03:25 AM. Reason: Added Attachment


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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