+ Reply to Thread
Results 1 to 12 of 12

PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDULE

  1. #1
    Registered User
    Join Date
    02-04-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    5

    PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDULE

    ok all. I'm in a bit of hot water with my wife. I promised her I could get this to work and so far I've run into a brick wall.

    I need a Reference formula to lookup dates(Within Range) that a specific employee is working.
    Attached Files Attached Files

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDUL

    I am pretty sure this is completely possible
    However, to avoid mis-communication here, what EXACTLY would you expect to see with the Info on your sample?
    If it's to hard to explain, put a few hand figured examples on your sample, it gives us something to check our answers with as well, I HATE offering a solution that misses what you want !
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  3. #3
    Registered User
    Join Date
    02-04-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDUL

    Ok, I've updated this sheet with Comments and a sample data return line
    Attached Files Attached Files

  4. #4
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDUL

    OOH...it is a bit of a complex one isn't it....
    this may take a bit, so be patient please

  5. #5
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDUL

    Any chance of same person working two shifts in one calendar day?...complcates things, but need to know if this is even going to be near accurate first time around...already starting to get lost...LOL

  6. #6
    Registered User
    Join Date
    02-04-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDUL

    Yes, One Person could theoretically work all 3 shifts(Notice there is either a name or a "X", I would like the "X" to pull availible shifts.

  7. #7
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDUL

    "X"?
    this does not appear in data or original post...what EXACTLY do you want from this question?...it started as a lookup of (basically) what shifts did (employee name work, as what,what dates) work ...now it's turning into???
    Id' rather you started out will all the information, rather than "we'll start here, then add this, then add this..." the formulas for first question may, in the end, have ABSOLUTELY nothing to do with what you really want...so please tell me where this "X" condition has appeared from?

  8. #8
    Registered User
    Join Date
    02-04-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDUL

    Sorry, busy night for the kids. Don't worry it's not an additional variable. I'm simply using Employee X to enable my wife to look at open shifts she needs to fill. That Schedule actually goes out to April of 2014. I really appriciate the help on this one. I've been trying to get this done for her for the last 6 months.

  9. #9
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDUL

    okay, would your wife be amendable to a "HELPER" sheet ?
    , which can be hidden, this single cell array formula is driving me insane because of the way the data is set up...using helper will speed up the lookup, the processing, can lead to a pivot table approach (which sounds like what you really need here, I just can't make one work the way the data is sorry), but it would in general speed up things...??


    Edit-
    I am 4 rows into the formula bar, and just starting to get results (WRONG, too) so I definitely hope this approach works...lol
    Last edited by dredwolf; 02-05-2013 at 03:28 AM.

  10. #10
    Registered User
    Join Date
    02-04-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    5

    Talking Re: PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDUL

    Priority #1-it works
    Priority #2-it looks the same

    Other than that she's be happy

  11. #11
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDUL

    Still working on it...

  12. #12
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDUL

    Still working on it, but this can never be 100% accurate, very little of the data in the schedule (oooh...say... the employee names), actually matches the stored data (..Employee list...), the abbreviations, concatenations, added #'s, etc. make this Data Almost impossile to work with..on the first date in the schedule I have one name impossible to resolve to a single person, and a second that in reality should come as impossible (Mag being the impossible one, Yolanda being the one that should be, only reason Yolanda resolves is because there IS an exact match for the name alone...)
    The abbreviations used are inconsistent, multiple people working same shift as same job....HOW does your wife expect you to create a sheet to lookup a certain person, on certain dates, when you can not even be sure the(possible) match is right???

    Sorry, but I don't think this is going to fly, will keep working on it for awhile, but unless the data your working on becomes more uniform, I do not see an easy/possible resolution to this
    Last edited by dredwolf; 02-07-2013 at 02:29 AM.

+ Reply to Thread

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