Results 1 to 7 of 7

Returning value if there is a difference

Threaded View

  1. #1
    Registered User
    Join Date
    02-25-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    28

    Question Returning value if there is a difference

    Hi all

    "In cell M7 I would need a formula to say if Cell M4 does not equal 0 then return the film, country and Product name of where the difference is"

    I have a issue with a reconciliation file that I thought should be simple, I have tried using some Index Match array's but have been unsucessful so far.

    I have attached a "small sample" in the workbook.

    I have a bunch of films in column B
    a Country, US, & Canada in column A (there would be a lot more) the films repeat
    A product code in column C
    and the amount sold in column D

    Then the same information from another source file in colums G-J

    In cell M4 there is a calculation to see if there is a difference between the two totals in row 30

    In cell M7 I would need a formula to say if Cell M4 does not equal 0 then return the film, country and Product name of where the difference is.

    Is there a way to return multiple differences, right now the difference lies in row 4, but if there was a difference in row 20 and row 29 also?

    Any help anyone can provide would be so amazing! I will as always try in the meantime!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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