+ Reply to Thread
Results 1 to 9 of 9

Comparing Data between sheets to find matches and no matches

  1. #1
    Registered User
    Join Date
    03-26-2015
    Location
    fayette, missouri
    MS-Off Ver
    2013
    Posts
    7

    Comparing Data between sheets to find matches and no matches

    I am currently using this formula to compare data between sheets to find out if there is a match or not. =IF(LOOKUP(A3,SHEET2!C:C)=A3,"MATCH","NO MATCH"). I am a bit of a newb to excel so this is all pretty new to me. This formula was given to me by a former employee so im not sure if it is the best one for my needs. basically I need the formula to search a specific column on the sheet I specify and indicate if there is a "match" or "no match". The issue I'm having is that sometimes it works great and sometimes it doesn't. I usually never get a false match but I frequently get "no match" when I can manually determine there is a match. And yes the data was an exact match and I tried to make sure the cell formatting was the same also. The format of the values are not consistent but I wouldn't think that would matter just thought it might be relevant. I feel like the formula works but some small issue is messing with it. I can create a new document and just make up some numbers and everything works fine. Any help and suggestions are appreciated. Please be very clear with any formula suggestions as I am very new to excel and have had no training on it.... Thanks in advance!
    -Tyson

  2. #2
    Forum Contributor
    Join Date
    06-21-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: Comparing Data between sheets to find matches and no matches

    Can you post a sample of the data, highlighting the false "no match"?

    Please ensure there are no identifying names, phone numbers, emails, etc.

  3. #3
    Registered User
    Join Date
    03-26-2015
    Location
    fayette, missouri
    MS-Off Ver
    2013
    Posts
    7

    Re: Comparing Data between sheets to find matches and no matches

    https://www.dropbox.com/s/iccshfbg17...MPLE.xlsx?dl=0

    Try that link. I removed everything sensitive and unnecessary. Thank you.

  4. #4
    Forum Contributor
    Join Date
    06-21-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: Comparing Data between sheets to find matches and no matches

    Hopefully someone else can help. File sharing sites like that are blocked by the firewall.
    Please remember to hit the Add Reputation for any member that has been helpful.

  5. #5
    Registered User
    Join Date
    03-26-2015
    Location
    fayette, missouri
    MS-Off Ver
    2013
    Posts
    7

    Re: Comparing Data between sheets to find matches and no matches

    screen shot.pngscreen shot 2.png

    Not sure if that worked, but here are some screen shots. Not sure that will help but its worth a shot I suppose.

  6. #6
    Registered User
    Join Date
    03-26-2015
    Location
    fayette, missouri
    MS-Off Ver
    2013
    Posts
    7

    Re: Comparing Data between sheets to find matches and no matches

    screen shot 2.png

    one more time.

  7. #7
    Registered User
    Join Date
    03-26-2015
    Location
    fayette, missouri
    MS-Off Ver
    2013
    Posts
    7

    Re: Comparing Data between sheets to find matches and no matches

    d6 formula.png

    This shows the formula being used in d6

  8. #8
    Registered User
    Join Date
    03-26-2015
    Location
    fayette, missouri
    MS-Off Ver
    2013
    Posts
    7

    Re: Comparing Data between sheets to find matches and no matches

    d6 formula.png

    trying again...

  9. #9
    Registered User
    Join Date
    03-26-2015
    Location
    fayette, missouri
    MS-Off Ver
    2013
    Posts
    7

    Re: Comparing Data between sheets to find matches and no matches

    d7 formula.png

    and here is the formula in d7

+ 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. Replies: 2
    Last Post: 09-15-2014, 09:58 AM
  2. Returning best matches after comparing data from 2 different sheets
    By Dolke in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-26-2013, 03:33 AM
  3. Replies: 0
    Last Post: 08-11-2012, 03:25 PM
  4. Comparing 3 or more columns to find matches
    By Spinnel in forum Excel General
    Replies: 7
    Last Post: 01-19-2009, 08:50 AM
  5. Comparing Columns to Find Matches
    By cultavix in forum Excel General
    Replies: 1
    Last Post: 11-07-2008, 11:06 AM

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