# 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:

=INDEX(Sheet!\$B\$4:\$BU\$701,MATCH(Name,Sheet!\$B\$4:\$B\$701,0),MATCH(Day,Sheet!\$B\$1:\$BU\$1,0))

(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:

[ATTACH=CONFIG]73985[/ATTACH]

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?

## Images

Re: Combining two conditional statements into one formula

That helped a lot. Before that I was placing the first paragraph in the beginning, but I changed the order and it gave me what I wanted. Thanks for your help

Hello,

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?