+ Reply to Thread
Results 1 to 3 of 3

How to merge data from two distinctive lists in Excel?

  1. #1
    Registered User
    Join Date
    10-28-2016
    Location
    London, UK
    MS-Off Ver
    Excel 2016
    Posts
    2

    Unhappy How to merge data from two distinctive lists in Excel?

    Untitled.png

    I have two distinct lists, one of companies, the others of contacts. I would like to automatically fill the name of the company on my contact list by using the information that is on the company list. How do I merge the information of my two lists? Is it possible to use INDEX and MATCH in this case?
    I don't even know how to phrase properly the problem so how could I write a formula that could work...

    Thank you for your help!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: How to merge data from two distinctive lists in Excel?

    In F4 use this:

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


    and copy down
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    10-28-2016
    Location
    London, UK
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: How to merge data from two distinctive lists in Excel?

    Thank you Jeff you are a star!!!

+ 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. Two lists - merge into one
    By baiaz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2016, 02:56 AM
  2. Merge two lists of data, preserving counts between them
    By tgambitg in forum Excel General
    Replies: 1
    Last Post: 05-07-2012, 03:56 PM
  3. merge two lists together
    By wlan in forum Excel General
    Replies: 1
    Last Post: 02-25-2012, 01:55 PM
  4. Match 3 sheets and get a distinctive output
    By lovinguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2011, 04:08 AM
  5. [SOLVED] Maximum value by distinctive year
    By adelkam in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-15-2010, 05:54 PM
  6. Merge & Sort Dynamic Lists with Data Validation
    By packetdog in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-05-2008, 09:26 AM
  7. [SOLVED] How can I merge different lists in Excel?
    By Nancie in forum Excel General
    Replies: 1
    Last Post: 01-06-2006, 09:40 AM

Tags for this Thread

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