+ Reply to Thread
Results 1 to 7 of 7

Match pairs from columns

  1. 04-22-2024, 12:06 AM #1
    naimickmac23 is offline
    Registered User
    Join Date
    01-24-2014
    Location
    New Alsace
    MS-Off Ver
    Excel 2016
    Posts
    7

    Match pairs from columns

    I'd like to know if there is a way to see if columns return matching values for the attached sheet. I'm trying to create a sports schedule. The schedule is weighted so I have to keep making changes and I want to make sure I don't have any matchups that are incorrect (I already did, that's why I need to check). For example in week 2. Team 1 (A2) plays Team 10 (B2). This is correct because Team 10 (A11) plays Team 1 (B11). This creates a sort of reverse pair (1,10) and (10,1) to give me the proper values. I feel like there has to be some sort of vlookup,xlookup, index-match, etc scenario that I can check this with some if statements or some other function, but I can't figure it out. Any help would be much appreciated.

    Screenshot_21Apr2024.png
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-22-2024, 12:59 AM #2
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,182

    Re: Match pairs from columns

    What EXACTLY do you want to check? What would be considered incorrect and why? HOW do you want to flag errors?

    Please add some manually created examples to the workbook so that we understand your expected outcomes.

    Are you still using Excel 2016?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-22-2024, 09:46 AM #3
    naimickmac23 is offline
    Registered User
    Join Date
    01-24-2014
    Location
    New Alsace
    MS-Off Ver
    Excel 2016
    Posts
    7

    Re: Match pairs from columns

    Can this post be deleted, thanks
    Reply With QuoteRegister To Reply
  4. 04-22-2024, 09:54 AM #4
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,182

    Re: Match pairs from columns

    Why? If you have found a solution, please share it here and mark the thread as solved.

    We do not delete threads for no good reason.
    Reply With QuoteRegister To Reply
  5. 04-22-2024, 09:57 AM #5
    naimickmac23 is offline
    Registered User
    Join Date
    01-24-2014
    Location
    New Alsace
    MS-Off Ver
    Excel 2016
    Posts
    7

    Re: Match pairs from columns

    I have no found a solution, but I don't know how I can questions any clearer and I don't really like your overall tone, so I'd like it removed and I'll figure it out by myself. Thanks
    Reply With QuoteRegister To Reply
  6. 04-22-2024, 10:26 AM #6
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,182

    Re: Match pairs from columns

    I am very sorry you don't like my 'tone', but I think we may have a language misunderstanding here. No offence was in any way intended.

    I was hoping to help you, but needed a few more details, namely:

    1. I need to know if you are still using Excel 2016 or something newer.
    2. I asked you to show me how you would like this to work - I am not entirely clear what you are looking for.

    Once again, the thread will not be removed and I would still like to help you.
    Reply With QuoteRegister To Reply
  7. 04-22-2024, 12:12 PM #7
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,671

    Re: Match pairs from columns

    In K2

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


    Copy across and down
    Attached Files Attached Files
    Last edited by JohnTopley; 04-22-2024 at 12:37 PM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Match sequential pairs
    By light in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-23-2022, 01:12 AM
  2. [SOLVED] Delete rows in pairs if columns value match and cells have opposite numbers.
    By elbarauljr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-17-2022, 12:08 PM
  3. [SOLVED] Match pairs with each another if not match highlight that pair
    By keshavtale in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2021, 06:22 AM
  4. Find Duplicates across 2 pairs of columns (2 columns against 2 columns)
    By erjfly2013 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-09-2015, 06:52 PM
  5. Need to define pairs in two columns and then build formula to compare these columns
    By tamara82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-30-2013, 04:58 PM
  6. Best layout to match pairs of data?
    By mikedavro in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-27-2010, 08:00 PM
  7. Counting Match Pairs In Rows
    By bmb2200 in forum Excel Formulas & Functions
    Replies: 67
    Last Post: 09-06-2005, 09: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1