+ Reply to Thread
Results 1 to 6 of 6

Comparing 2 columns of data to check if it matches a 3rd Column of data

  1. #1
    Registered User
    Join Date
    02-10-2016
    Location
    Wayne, NJ
    MS-Off Ver
    2016
    Posts
    21

    Comparing 2 columns of data to check if it matches a 3rd Column of data

    Hello,

    I have 3 columns

    Column A - first name
    Column B- last name
    Column C - Contains both the first and last name (Although this was pasted from another source).

    I need to make sure the first and last names in Column C are an exact match to the first and last names from column A and B.

    I am trying to get an If statement in Column D to produce an error if they are not a match?

    Is this possible??

    Thank you!
    Babs
    Last edited by sophielane; 02-10-2016 at 01:42 PM.

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Comparing 2 columns of data to check if it matches a 3rd Column of data

    Assuming your data starts from A1 onwards

    in d1=EXACT(A1&" "&B1,C1)
    red part represents a space in case your first name is separated by comma in that case change red part to ","

    formula provided here performs case sensitivity
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Registered User
    Join Date
    02-10-2016
    Location
    Wayne, NJ
    MS-Off Ver
    2016
    Posts
    21

    Re: Comparing 2 columns of data to check if it matches a 3rd Column of data

    Hello,

    Well, I did try this and some are coming up false, that should not be?
    I don't see any extra spaces? and I tried to make a few myself with simple copy in both columns and then putting that name in the 3rd one manually and it comes up false?

    Do you know why they would be false?

    Thank you!!!!
    Babs

  4. #4
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Comparing 2 columns of data to check if it matches a 3rd Column of data

    with above formula

    Red Brown is not equal to red brown

    if thats the case try below in D1
    =A1&" "&B1=C1

  5. #5
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Comparing 2 columns of data to check if it matches a 3rd Column of data


  6. #6
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Comparing 2 columns of data to check if it matches a 3rd Column of data

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

+ 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. Comparing two columns and if there is a match...
    By Carmine in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2015, 10:03 AM
  2. Replies: 1
    Last Post: 08-18-2014, 11:10 PM
  3. Comparing columns and deleting those that do not match
    By Insert Name in forum Excel General
    Replies: 11
    Last Post: 01-01-2013, 06:16 PM
  4. [SOLVED] Comparing Two Columns and Copy Adjacent Column IF Match Found
    By 10AVATAR in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-29-2012, 04:33 PM
  5. [SOLVED] Comparing two columns and displaying a third value if they match
    By pdxcollegegrl in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-29-2012, 12:46 PM
  6. Comparing multiple columns using MATCH
    By krpandrei in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2012, 10:21 AM
  7. Comparing 2 columns- if a match is found return a value in 3rd column
    By lineson in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-20-2011, 04:48 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