+ Reply to Thread
Results 1 to 5 of 5

Pull data based on date and name (2 variables -- INDEX/MATCH or VLOOKUP?)

  1. #1
    Registered User
    Join Date
    02-21-2022
    Location
    Seattle
    MS-Off Ver
    Excel 16.58
    Posts
    3

    Pull data based on date and name (2 variables -- INDEX/MATCH or VLOOKUP?)

    Hello! I am trying to streamline tip tracking for a local restaurant. My goal is to have ONE data entry page that will fill the rest of the tabs.

    Background: Employees take some tips home at the end of their shift AND are also owed tips (ie. if there isn't enough cash at the end of the night to cover all the credit card tips). I'd like to have one data entry page that lists what employees took home ("paid") and what they are "owed." The next sheet/tab would pull just the "owed" amount based on the employee name and the date. For example, if Jane was paid $10 and owed $40 on 3/3/2022, the 2nd sheet/tab would use "Jane-OWED" and "3/3/2022" to pull the value $40. Please see example spreadsheet attached for clarification.

    I don't want to simply reference cells (ie. sum) because there is high turnover so we're constantly adding/removing employees which screws up the cell referencing.

    THANK YOU!!!
    Attached Files Attached Files

  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: Pull data based on date and name (2 variables -- INDEX/MATCH or VLOOKUP?)

    In C3, copied down:

    =INDEX('Data Entry'!$C$2:$D$33,MATCH(A3,'Data Entry'!$A$3:$A$33,0),MATCH(C$1,'Data Entry'!$C$1:$D$1,0))
    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
    Registered User
    Join Date
    02-21-2022
    Location
    Seattle
    MS-Off Ver
    Excel 16.58
    Posts
    3

    Re: Pull data based on date and name (2 variables -- INDEX/MATCH or VLOOKUP?)

    Thank you!!

  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: Pull data based on date and name (2 variables -- INDEX/MATCH or VLOOKUP?)

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

  5. #5
    Registered User
    Join Date
    02-21-2022
    Location
    Seattle
    MS-Off Ver
    Excel 16.58
    Posts
    3

    Re: Pull data based on date and name (2 variables -- INDEX/MATCH or VLOOKUP?)

    Done. Thank you for letting me know!

+ 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. Do Index Match Match to pull data from multiple worbooks
    By lecorrea in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-24-2020, 10:07 PM
  2. Complex Index/match formula to pull data based on 1 criteria. (Bid/Cost Sheet)
    By Blackmagic42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-18-2019, 01:45 AM
  3. Replies: 4
    Last Post: 04-14-2017, 07:47 PM
  4. Replies: 3
    Last Post: 05-19-2014, 02:01 PM
  5. [SOLVED] Vlookup or index match with 2 or more variables
    By jasonleewkd in forum Excel General
    Replies: 7
    Last Post: 12-14-2012, 04:51 AM
  6. Pull data based on date match
    By tommypkoch in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2012, 11:13 AM
  7. Repeating Variables-VLOOKUP or INDEX/MATCH?
    By jbritt609 in forum Excel General
    Replies: 4
    Last Post: 06-10-2009, 01:16 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