+ 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
    MS-Off Ver
    MS Office 365
    Posts
    20,729

    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

  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
    MS-Off Ver
    MS Office 365
    Posts
    20,729

    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. [SOLVED] How do I use lookup to return multiple matches and sum them?
    By Nat in forum Excel General
    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