+ Reply to Thread
Results 1 to 5 of 5

Formula that compares 2 spreadsheets

  1. #1
    Registered User
    Join Date
    08-02-2004
    Posts
    11

    Formula that compares 2 spreadsheets

    I'm sure this is easy but I can't get my head around it.

    I need to compare 2 spreadsheets to identify if the same data is on each sheet.

    See attached file. If the number (Column B) and type (COLUMN C) in sheet 1 is anywhere on sheet 2 (columns A and B, in the same combination) insert ‘OK’ in column D on sheet 1. Both sheets could have hundreds of rows.

    I need a formula, rather than VBA/Macro.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,781

    Re: Formula that compares 2 spreadsheets

    On Sheet 2 Cell C2 Put this formula and drag down as required

    =A2&B2

    Then on Sheet1 Cell D2, put this one and drag down as required

    =IF(ISNUMBER(MATCH(B2&C2,Sheet2!C:C,0)),"OK","")
    Cheers!
    Deep Dave

    www.NeedForExcel.com

  3. #3
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,872

    Re: Formula that compares 2 spreadsheets

    This question has been asked a zillion times, on the forum as well as on the Web. Perhaps try the forum's search tool

  4. #4
    Registered User
    Join Date
    08-02-2004
    Posts
    11

    Re: Formula that compares 2 spreadsheets

    Deep Dave, thanks for your solution. Simple and effective, even I can understand it.

    Pepe, I did search the Forum but couldn't narrow down the posts enough to answer my query. I am not a fool, although obviously not in your exalted league, but I do object to being patronised. If you have a positive comment to make, please make it. If your contribution is only to criticise, I would suggest keeping your thoughts to yourself.

  5. #5
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,781

    Re: Formula that compares 2 spreadsheets

    Hi,

    Glad I could help..

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Formula that compares two columns and ignores end characters.
    By tfahey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-14-2015, 12:46 PM
  2. [SOLVED] If formula that compares Quantity before selecting a range to use
    By KARENKERBA in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2014, 12:07 AM
  3. Replies: 3
    Last Post: 12-12-2012, 11:52 AM
  4. Replies: 0
    Last Post: 08-17-2011, 10:09 AM
  5. Macro that compares two spreadsheets and copies to 1
    By ucsutah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2011, 01:11 AM
  6. Replies: 2
    Last Post: 07-01-2008, 09:19 AM
  7. formula that compares different ranges
    By sir Lancelot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-13-2005, 04:20 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