+ Reply to Thread
Results 1 to 5 of 5

Comparing Cells from different spreadsheets with each other and giving different results

  1. #1
    Registered User
    Join Date
    09-26-2014
    Location
    Interlaken, Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    12

    Comparing Cells from different spreadsheets with each other and giving different results

    Hello everyone,

    I need some help here.

    I want a formula which checks the priority of an item and compares the stock with the minimun stock level and if it's lower than the mininum stock level it should say in column status 'order' or if it's more or as much as the minimun it should say 'in stock'.
    Also there's an exception, there are items which are not in stock and only in a list, because they are per order.
    I'll try to explain it again with an example.
    The priority for pencils is high, there are 20 in stock, but it should have at least 25. Now the column status should say 'order'.
    How can I do that?
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,263

    Re: Comparing Cells from different spreadsheets with each other and giving different resul

    Not much clear about the expected results, need more clarify:

    Is it the low, high, average stock for all items? Explain it at your sample workbook with before and after situation.

    Cheers

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Comparing Cells from different spreadsheets with each other and giving different resul

    Try this.....
    On Writing Utensils Sheet
    In D2
    Please Login or Register  to view this content.
    Is this what you are trying to achieve?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Registered User
    Join Date
    09-26-2014
    Location
    Interlaken, Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Comparing Cells from different spreadsheets with each other and giving different resul

    Quote Originally Posted by sktneer View Post
    Try this.....
    On Writing Utensils Sheet
    In D2
    Please Login or Register  to view this content.
    Is this what you are trying to achieve?
    Thank you, this was exactly what I wanted. Thanks a lot.

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Comparing Cells from different spreadsheets with each other and giving different resul

    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. Trying to display results after comparing 2 cells on different sheets
    By Lylebrous in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-03-2014, 06:22 PM
  2. [SOLVED] Comparing multiple cells and giving a summary report
    By bwood7 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-10-2013, 05:03 PM
  3. Comparing Multiple Cells in different rows and copying results
    By Eric@Gopher in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-10-2012, 05:46 PM
  4. Excel 2007 : Comparing cells to find best results
    By berk21 in forum Excel General
    Replies: 7
    Last Post: 11-04-2009, 06:46 PM
  5. Comparing contents of two spreadsheets and outputting results to a
    By brx in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-16-2005, 10:06 PM

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