+ Reply to Thread
Results 1 to 11 of 11

Combine multipe VLOOKUP results

  1. #1
    Registered User
    Join Date
    07-31-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    8

    Combine multipe VLOOKUP results

    I'm looking for a formula that combines unique results for a VLOOKUP function (at least, I think that is the right function), where the column with results has different values for the same VLOOKUP value.
    Please see attached Example.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Combine multipe VLOOKUP results

    Please try this.
    Attached Files Attached Files
    Please click 'Add reputation', if my answer helped you.

  3. #3
    Registered User
    Join Date
    07-31-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: Combine multipe VLOOKUP results

    Quote Originally Posted by ramananhrm View Post
    Please try this.
    Thanks, that does the trick, however, in my case there are many multiple 'Companies' in table B1:C12. As a result, I will get a long horizontal list of values in table E16:G21 (so that table will have many columns). Is there a way to prevent this?

  4. #4
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Combine multipe VLOOKUP results

    Give me a sample data.
    Let me try.

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    6,004

    Re: Combine multipe VLOOKUP results

    Pl see the attached file.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    07-31-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: Combine multipe VLOOKUP results

    Quote Originally Posted by kvsrinivasamurthy View Post
    Pl see the attached file.
    Thanks, that seems to work, but would it be possible to exclude duplicates (see your results for Company D versus the desired output for Company D)?

  7. #7
    Registered User
    Join Date
    07-31-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: Combine multipe VLOOKUP results

    Quote Originally Posted by ramananhrm View Post
    Give me a sample data.
    Let me try.
    Hi, the sample data would be many more rows of Company A, B, C and D with repeated Types (Type 1 and Type 2).
    So duplicates in the source table.
    Last edited by Rubbertje; 07-31-2013 at 09:37 AM.

  8. #8
    Registered User
    Join Date
    07-31-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: Combine multipe VLOOKUP results

    ..........
    Last edited by Rubbertje; 07-31-2013 at 10:57 AM.

  9. #9
    Registered User
    Join Date
    07-31-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: Combine multipe VLOOKUP results

    Quote Originally Posted by kvsrinivasamurthy View Post
    Pl see the attached file.
    By the way, when I want to run the macro (for a refresh), I get an "Argument not optional" error.

  10. #10
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    6,004

    Re: Combine multipe VLOOKUP results

    Pl see attached file with Macro.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    07-31-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: Combine multipe VLOOKUP results

    Quote Originally Posted by kvsrinivasamurthy View Post
    Pl see attached file with Macro.
    Thanks a lot, that worked!

+ 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. How to combine results of several if clauses in one formula?
    By DaJackal in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-30-2013, 10:01 PM
  2. Combine Value of 5 Cells and List Results
    By Andrew.Trevayne in forum Excel General
    Replies: 3
    Last Post: 06-29-2011, 08:30 AM
  3. Formula to combine 2 results
    By ssdsibes in forum Excel General
    Replies: 6
    Last Post: 11-17-2010, 06:49 PM
  4. Combine Coinciding Results.
    By zealot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2009, 07:51 PM
  5. CountIF - combine results from two columns
    By tahirawan11 in forum Excel General
    Replies: 10
    Last Post: 02-17-2009, 09:56 AM

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