+ Reply to Thread
Results 1 to 3 of 3

Matching Two Groups of 5 columns

  1. #1
    Registered User
    Join Date
    08-20-2018
    Location
    Mass, USA
    MS-Off Ver
    MS365 version 2303
    Posts
    28

    Question Matching Two Groups of 5 columns

    I have two groups of data (A and B), each with five columns of measurements: diameter, width, ect.

    I want to have excel to match the columns of data group A to data group B only if all of the columns match.

    Example:

    2 14 3 7 8 = 2 14 3 7 8

    So far I've tried using power query, but it seems like I can only match one column to one column.

    Any ideas?

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Matching Two Groups of 5 columns

    what exactly is it you want to do and what do you have?
    is it like sheet1 A1, B1, C1, D1 and E1 and you want to match to sheet2 A1, B1, C1, D1 and E1? And you want it to be Sheet1A1=Sheet2A1, not for example that the numbers would all match but be in a different order - like Sheet1A1 value is in Sheet2B1?
    are you looking for it to match row by row?
    wouldn't simply =IF(AND(Sheet1!A1=Sheet2!A1,Sheet1!B1=Sheet2!B1,Sheet1!C1=Sheet2!C1,Sheet1!D1=Sheet2!D1,Sheet1!E1=Sheet2!E1),"all match","don't match") work?
    OR, are they in different rows and you are trying to search them out?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Contributor
    Join Date
    05-16-2018
    Location
    Pittsburgh, PA
    MS-Off Ver
    2016
    Posts
    109

    Re: Matching Two Groups of 5 columns

    For better help, please attach a sample workbook

    Go Advanced (bottom of thread)
    Additional Options Box (bottom of post reply box)
    Attachments, click manage attachments
    Upload from computer or wherever, click Upload
    Close window,
    Then Submit Reply

+ 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. Matching Date From Two Groups
    By wsteel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  2. [SOLVED] Matching Date From Two Groups
    By Biff in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 06:05 AM
  3. Matching Date From Two Groups
    By Biff in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 04:05 AM
  4. [SOLVED] Matching Date From Two Groups
    By wsteel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. Matching Date From Two Groups
    By wsteel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  6. Matching Date From Two Groups
    By wsteel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Matching Date From Two Groups
    By wsteel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. Matching Date From Two Groups
    By wsteel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2005, 10:05 PM

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