+ Reply to Thread
Results 1 to 2 of 2

Cell value matches value from Sheet1. Compare number from Cell2 and show difference

  1. #1
    Registered User
    Join Date
    04-25-2014
    Location
    Coalville
    MS-Off Ver
    Excel 2010
    Posts
    5

    Question Cell value matches value from Sheet1. Compare number from Cell2 and show difference

    Hi All

    I will do my best to describe what I need to achieve. If description not clear enough please shout up. We will work it through somehow

    OK...

    Sheet1 is Main Sheet which never will be amended and these numbers will be a source for pulling mathematical functions
    See attached :
    Sheet1.png
    Don't be bothered about cell colors etc. They are for my reference

    Sheet2
    Will contain same Problem Ticket numbers but different (or same) values with number of 'Linked Incidents'
    See screenshot
    Sheet2.png

    Based on Problem ID 10248
    Main sheet shows 92 Linked Incidents
    Value on Sheet two brings 93

    If A5 Sheet2 value can be found in ColumnA Sheet1, look for a number in ColumnC, same ROW and compare it to C7 in Sheet2 ?
    Bring up difference value, which in this case would be one

    Any help appreciated ! Thanks for looking

  2. #2
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Cell value matches value from Sheet1. Compare number from Cell2 and show difference

    Hi,

    See the sample workbook to set up a comparison between the two sheets
    Attached Files Attached Files
    Regards,
    Rudi

+ 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. Show Difference of sheet1-sheet2 in sheet3 if items match?
    By nyichiban in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2013, 04:03 PM
  2. Replies: 9
    Last Post: 08-15-2013, 01:44 PM
  3. Compare two reports and show difference in another tab
    By humsboyle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-31-2013, 01:49 PM
  4. Replies: 2
    Last Post: 02-10-2013, 05:54 PM
  5. [SOLVED] Change input number to red in sheet1 when it matches number in sheet2
    By Kent Kelly in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-06-2012, 04:44 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