Posts by n4t4s

    I'm trying to find a way to find to use 3 references to return a value using INDEX and MATCH, but whenever I'm using a third reference, Excel gives me the #REF! error, i.e., I want do a formula that finds the start time of an employee. First I'm matching name and day like this:


    (this is using one horizontal and one vertical match, and until this point, everything works fine)

    The problem is when I want to add a third MATCH where: MATCH(Shift Start, Sheet!$B$3:$BU$3,0)

    Taking in consideration the raw data displayed is like this:


    and I want the range to be dynamic depending if what we want to get is the Shift Start or the Break 2 End on a Monday, but using the same formula. Any thoughts?


    I need help with the following statement:

    I want to do a graphic schedule in Excel, so I was using the current formula:

    =IF(AND(I2>=$C3,J2<=$D3),1," ")

    Where I2 is the start time and J2 is the end time and C3 and D3 are 15 min intervals, but the problem that I'm facing is when I want to also put the break time using this formula:

    =IF(AND(I2>=$E3,J2<=$F3),2," ")

    Where E3 and F3 are the start and end time of the break in question

    How could I combine both?