+ Reply to Thread
Results 1 to 2 of 2

Trying to display results after comparing 2 cells on different sheets

  1. #1
    Registered User
    Join Date
    Waterford, Michigan
    MS-Off Ver

    Trying to display results after comparing 2 cells on different sheets

    Good morning,
    I have been banging my head against the wall trying to figure out this one. Any help would be great.

    I have an Excel 2013 workbook with multiple sheets in it. There is a MASTER page and multiple subordinate pages. This workbook is used to calculate employee commission and in turn place all the data on one sheet so it can be turned into the accountant. I have tried using VLOOKUP as well as 4 or 5 other options. None have produced what I am trying to achieve. Perhaps I am wanting something not possible. Here is a screen shot of the 2 pages. Below I will outline how they work and what I need.

    Each employee will have their own sheet that will track their sales and the commission they get. On the sheet I only have 4 areas that are not locked, those are depicted with green cells. So the boss only needs to type the info in and it will calculate. This sheet is functioning fine.

    On the master I have created a Data Validation drop down box to pull the payroll dates from the second sheet in column B. This is set as Check_Date

    I am trying to select the check date from the drop down and have the data from the subordinate sheet pulled into the master. The only 2 pieces I need are PAYABLE and CASH TIPS. The number would come from the row that corresponds to the date in the drop down. This info needs to be pulled from each sheet that corresponds to a user on the master page

    I am not sure if I need to add an index column to make this work or what.

    Any help or suggestions are very much appreciated.
    Last edited by Lylebrous; 07-03-2014 at 11:01 AM. Reason: Added more detail

  2. #2
    Forum Expert
    Join Date
    Austin, TX
    MS-Off Ver
    Excel 2010

    Re: Trying to display results after comparing 2 cells on different sheets

    VLOOKUP should work. Use the date in the Master sheet to look through the table for Zarko and get the cash to be paid. Do that for each person.

    Note - attaching a spreadsheet is much friendlier than pictures. With pics we can't test our ideas (unless we recreate your data). Also, if your sheets are set up a certain way, you could make the VLOOKUP use the person's name so you have a more universal formula, but I don't know your sheet structure.
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ 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. Macro to search other sheets and display results if there are any
    By stumpedintern in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2014, 04:06 PM
  2. 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
  3. Replies: 1
    Last Post: 09-27-2011, 12:10 PM
  4. Cells don't display formula results
    By Frankf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2010, 02:50 PM
  5. Excel 2007 : Comparing cells to find best results
    By berk21 in forum Excel General
    Replies: 7
    Last Post: 11-04-2009, 06:46 PM


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