+ Reply to Thread
Results 1 to 4 of 4

Compare and return difference in values between two tabs

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Compare and return difference in values between two tabs

    Hi guys,

    I have employee names and two sets of values.

    I want a vlookup and or way to return the difference in column B and Column D to return the values. The names in column A will be in different order....

    I.e. In cell C2 on my march and feb tabs, I want a formula to show what is the difference between cell b2 in march and cell b2 in feb for the name in cell A2
    In cell d2 on my march and feb tabs, I want a formula to show what is the difference between cell d2 in march and cell d2 in feb for the name in cell A2


    Can anyone help please?

    I am trying this in cell C2: =VLOOKUP($A2,Feb!A:D,2,FALSE)-B2 (ON THE MARCH TAb). IS this the best way? it would be good to show the positive and negative numbers..
    Attached Files Attached Files
    Last edited by rayted; 03-26-2021 at 07:43 AM.
    Thanks,

    R.



  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,036

    Re: Compare and return difference in values between two tabs

    It's fine... I'd probably use this:
    =IF($A2="","",IFERROR(SUMIF(Feb!$A:$A,$A2,Feb!B:B)-B2,""))

    whcih can be copy/pasted into D as well... without any modification.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: Compare and return difference in values between two tabs

    TY so much Glenn!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,036

    Re: Compare and return difference in values between two tabs

    You're welcome and thanks for the feedback!

+ 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. [SOLVED] Compare 2 columns in different tabs and add new values
    By rz6657 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-06-2020, 01:31 PM
  2. [SOLVED] Finding the difference in 2 values from 2 different tabs
    By CherryM2015 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-13-2018, 06:35 AM
  3. [SOLVED] compare tabs and return results in report tab
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-04-2014, 12:04 PM
  4. Replies: 0
    Last Post: 10-07-2013, 10:24 AM
  5. [SOLVED] Compare 2 columns on different sheets & return current % difference as year progresses
    By Big.Moe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-31-2013, 03:29 AM
  6. Compare two values target v actual = difference
    By owlservice in forum Excel General
    Replies: 3
    Last Post: 05-22-2011, 05:45 PM
  7. Compare letters in two cells, return difference
    By mkvassh in forum Excel General
    Replies: 2
    Last Post: 04-11-2011, 02:51 AM

Tags for this Thread

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