+ Reply to Thread
Results 1 to 5 of 5

Please help :( Lookup value return multiple matches

  1. #1
    Registered User
    Join Date
    05-22-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    5

    Please help :( Lookup value return multiple matches

    Hi All, I'm hoping you can help me.

    I need to look up value (A2) from sheet1 on sheet2 (A2) and return the corresponding value (B2)

    Now, I know how to do a vlookup etc but I'm a little stuck because there are multiple matches on sheet2 but they have individual values in (B2). I need to return all matching results (B2) horizontally.

    I have tried array formulas with INDEX and IF statements but it has beaten me

    See photos attached (sorry if the sizing is terrible! Never uploaded attachments here before)

    Essentially If the customer order number (A2 Sheet1) appears multiple times in (Column A Sheet2) I needs to return the (workflow) results found in (Column B Sheet2) to populate horizontally on Sheet1

    I hope I have explained that clearly. :-/

    Thank you in advance
    Attached Images Attached Images

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Please help :( Lookup value return multiple matches

    Here is some VBA code that was developed by Krishnakumar. Attached is a worksheet that explains how to employ this UDF

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    05-22-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Please help :( Lookup value return multiple matches

    Sorry, that is way above my head. I have no idea how to do that. I don't understand the spreadsheet that is attached. I tried just replacing the data in it but I can't get it to work.

  4. #4
    Registered User
    Join Date
    05-22-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Please help :( Lookup value return multiple matches

    If it helps, I have attached the spreadsheet
    Attached Files Attached Files

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Please help :( Lookup value return multiple matches

    Here is another option. http://www.mrexcel.com/forum/excel-q...-function.html

    How to install your new code
    1. Copy the Excel VBA code
    2. Select the workbook in which you want to store the Excel VBA code
    3. Press Alt+F11 to open the Visual Basic Editor
    4. Choose Insert > Module
    5. Edit > Paste the macro into the module that appeared
    6. Close the VBEditor
    7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Lookup Values which meet two or more criteria and return multiple matches horizontally
    By josetmg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-03-2015, 01:16 AM
  2. Lookup and return multiple matches across multiple sheets
    By somnath6309 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2013, 02:44 AM
  3. Lookup and return multiple matches across multiple sheets
    By somnath6309 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2013, 03:45 PM
  4. [SOLVED] Lookup and Return Multiple Matches
    By TroyDawes in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-16-2013, 10:00 PM
  5. lookup formula to return data where column header matches
    By tim-harrison in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-06-2013, 12:58 AM
  6. Replies: 5
    Last Post: 02-08-2011, 09:07 AM
  7. Replies: 1
    Last Post: 08-15-2006, 01:25 PM

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