+ Reply to Thread
Results 1 to 2 of 2

Show Difference of sheet1-sheet2 in sheet3 if items match?

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Show Difference of sheet1-sheet2 in sheet3 if items match?

    Basically I have two lists in sheet 1 and sheet 2. Column a is the item number and col b is the quantity. In sheet 3 I basically want it to show all items in col a and in col b the difference of sheet 1 - sheet 2. If the same items don't exist it will just now show up. Is this something to do with vlookup?

    EDIT: Attached sample file.
    Attached Files Attached Files
    Last edited by nyichiban; 10-23-2013 at 01:49 PM. Reason: Sample file added

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

    Re: Show Difference of sheet1-sheet2 in sheet3 if items match?

    Hello ! try this in sheet 3 in B3
    =IFERROR(VLOOKUP(A3,Sheet1!$A$2:$B$6,2,0),0)-IFERROR(VLOOKUP(A3,Sheet2!$A$2:$B$5,2,0),0)

    this formula will count 0 for the item if item does not exist in any of the sheet i.e. 1003 is not available in sheet 2 but is available in sheet 1 then result will be 11-0=11, if we reverse it then 0-11= -11
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    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

+ 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] A1, Sheet1 minus A1, Sheet2. Result in A1, Sheet3.
    By nkormanik in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2013, 07:18 PM
  2. Macro keeps looking for sheet1, won't use sheet2, sheet3 . . .
    By salvator in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2011, 10:12 PM
  3. Excel 2007 : Compare: Sheet1 - Sheet2 into Sheet3
    By vbjohn in forum Excel General
    Replies: 3
    Last Post: 07-17-2009, 03:33 PM
  4. Transfer data from sheet1 to sheet2 and sheet3
    By vbosmiya in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2007, 11:42 PM
  5. A1 in sheet1 =” =SUM('sheet2:sheet3'!A1)”
    By minrufeng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2006, 03:10 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