+ Reply to Thread
Results 1 to 3 of 3

lookup and match with multiple conditions

  1. #1
    Registered User
    Join Date
    11-02-2013
    Location
    North Queensland Australia
    MS-Off Ver
    Excel 2007
    Posts
    44

    lookup and match with multiple conditions

    Hi There,
    I am looking for a formula that will lookup an array with multiple match conditions.
    the file is attached and I have highlighted the sections involved to try and make it easier to see what i am looking for.
    Thank you for any help you can provide
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: lookup and match with multiple conditions

    The colors in your sample workbook aren't clear. Can you adjust them and reupload?
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    11-02-2013
    Location
    North Queensland Australia
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: lookup and match with multiple conditions

    Here is the updated version.
    The colours are just to highlight the sections involved in the formula.
    The actual sheet will not have them.
    Currently I manually look at each days shift.
    If there is a shift that start at or before 7.00am, or finishes after 6.00pm. then I look across that row to the shift hours and manually add the hours.
    This is the section I would like to be able to calculate automatically.
    The weekends are not to be included in the formulas

    Thanks for the help.
    Attached Files Attached Files

+ 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. Replies: 2
    Last Post: 01-26-2015, 04:53 AM
  2. Replies: 2
    Last Post: 12-18-2014, 09:52 AM
  3. Replies: 13
    Last Post: 12-13-2012, 11:44 AM
  4. Lookup multiple partial match conditions and return values
    By darklans in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-18-2012, 03:26 AM
  5. multiple lookup with multiple match conditions
    By znaya in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2008, 06:05 AM

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