+ Reply to Thread
Results 1 to 6 of 6

Compare two different columns as a match or no match

  1. #1
    Registered User
    Join Date
    07-13-2015
    Location
    New York, NY
    MS-Off Ver
    2013
    Posts
    5

    Compare two different columns as a match or no match

    I have a spreadsheet that I need a formula to look at either cells D2 and B2 match or if cells E2 and C2 match and if either do to provide the result of YES and if neither do the result NO. I have tried multiple IF OR IF AND etc formulas with no success. Need a formula that works.


    Here is an example:
    Screen Shot 2019-01-15.jpg
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Re: Compare two different columns as a match or no match

    Try
    =IF(EXACT(E2,C2)=EXACT(D2,B2),"yes","no")

  3. #3
    Registered User
    Join Date
    07-13-2015
    Location
    New York, NY
    MS-Off Ver
    2013
    Posts
    5

    Re: Compare two different columns as a match or no match

    Thanks but did not work as when one of the columns(D or E) has #N/A in it the result but has a matches columns B or C the result is #N/A in F
    Need the result to be if E=C or if D=B to show that result and if #N/A is the result then "NO MATCH"

  4. #4
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Re: Compare two different columns as a match or no match

    Try one more time
    =IFERROR(IF(EXACT(E2,C2)=EXACT(D2,B2),"Yes","No"),"No Match")

  5. #5
    Registered User
    Join Date
    07-13-2015
    Location
    New York, NY
    MS-Off Ver
    2013
    Posts
    5

    Re: Compare two different columns as a match or no match

    Still no good
    EXCEL.JPG

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,534

    Re: Compare two different columns as a match or no match

    If I understand correctly then the following should yield the desired answer: =IF(OR(IFERROR(B2=D2,FALSE),IFERROR(C2=E2,FALSE)),"Yes","No")
    If this doesn't work then I would suggest showing us, preferably by uploading a spreadsheet, the expected responses for rows 5:9.
    To upload a spreadsheet click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Compare Date both Full match/ partial match between two columns
    By cyboincomp in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-21-2018, 03:02 AM
  2. Replies: 6
    Last Post: 09-21-2016, 04:21 PM
  3. Compare two columns, One to two match
    By kennethwu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2016, 12:05 PM
  4. Macro to Compare two columns and publish sheet name in case columns dont match
    By adaws in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2014, 01:21 PM
  5. Compare/Match two columns
    By heartstealer in forum Excel General
    Replies: 3
    Last Post: 11-08-2010, 07:37 AM
  6. Compare/Match two columns
    By heartstealer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-07-2010, 03:18 PM
  7. Can't use match to compare two columns
    By AC169 in forum Excel General
    Replies: 6
    Last Post: 04-16-2009, 04:58 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