Results 1 to 2 of 2

Thread: LOOK UP FORMULA, Data extraction

  1. #1

    LOOK UP FORMULA, Data extraction



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Everyone,

    I've been trying to do a 2 criteria lookup funciton, but to no avail. I've also tried to use an aggregate formula, and Index/match but none worked below is a sample of the data. I'm looking to extract the data to match the Date, which is a data validation list, from the Employee and Shift_time Columns.
    Any assistance is greatly apprecaited

    Sun 4/21/2013 Sun 4/21/2013 Mon 4/22/2013 Mon 4/22/2013 Tue 4/23/2013 Tue 4/23/2013 Wed 4/24/2013 Wed 4/24/2013
    Sun 4/21/2013 EMPLOYEE SHIFT_TIME EMPLOYEE SHIFT_TIME EMPLOYEE SHIFT_TIME EMPLOYEE SHIFT_TIME
    JON DOE1 03:00-11:30 JOHN DOE 1 03:00-11:30 JANE DOE 1 03:00-11:30
    EMPLOYEE SHIFT JON DOE2 03:30-08:30 JON DOE2 03:00-11:30 JOHN DOE 2 03:30-08:30 JANE DOE 2 03:30-08:30
    JON DOE3 03:30-08:30 JON DOE3 03:30-08:30 JOHN DOE 3 03:30-12:00 JANE DOE 3 03:30-08:30
    JON DOE4 03:30-12:00 JON DOE4 03:30-08:30 JOHN DOE 4 03:30-12:00 JANE DOE 4 03:30-08:30
    JON DOE5 03:30-12:00 JON DOE5 03:30-08:30 JOHN DOE 5 03:30-12:00 JANE DOE 5 03:30-08:30
    JON DOE6 03:30-12:00 JON DOE6 03:30-12:00 JOHN DOE 6 03:30-12:00 JANE DOE 6 03:30-12:00



    Thank you
    MZING81

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,336
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Layout and formatting can be important here. Please post a sample sheet

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •