BrandonBerner
New Member
- Joined
- Mar 16, 2019
- Messages
- 15
Here is the formula which I am using.
=INDEX($A$1:$H$15,MATCH($A$18,$A$1:$A$15,0),MATCH(B$18,$B$2:$H$2,0),MATCH($A19,$A$3:$A$15,0))
Here is the same formula, which explains the above formula, and what I'm looking to achieve.
=INDEX(Full_Schedule,MATCH(Data_Validation(Week1|Week2),Where_Week1_&_Week2_Are_Found,0),MATCH(Day_Of_The_Week,Where_Day_Of_The_Week_Is_Found_In_Full_Schedule,0),MATCH(Employee_Name,Where_Employee_Name_Is_Found_In_Full_Schedule,0))
Here is the sheet im working with...
[TABLE="width: 0"]
<tbody>[TR]
[TD="align: center"]Week1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SUN[/TD]
[TD]MON[/TD]
[TD]TUE[/TD]
[TD]WED[/TD]
[TD]THUR[/TD]
[TD]FRI[/TD]
[TD]SAT[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #1[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="align: right"]Employee #2[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #3[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="align: right"].Employee #4[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]12:15-6:15[/TD]
[TD="align: center"]12:15-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #5[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]12:15-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]Week2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SUN[/TD]
[TD]MON[/TD]
[TD]TUE[/TD]
[TD]WED[/TD]
[TD]THUR[/TD]
[TD]FRI[/TD]
[TD]SAT[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #1[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="align: right"]Employee #2[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #3[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="align: right"].Employee #4[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]12:15-6:15[/TD]
[TD="align: center"]12:15-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #5[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]12:15-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Week1 v[/TD]
[TD="align: center"]SUN[/TD]
[TD="align: center"]MON[/TD]
[TD="align: center"]TUE[/TD]
[TD="align: center"]WED[/TD]
[TD="align: center"]THUR[/TD]
[TD="align: center"]FRI[/TD]
[TD="align: center"]SAT[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #1[/TD]
[TD]FORMULA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Employee #2[/TD]
[TD]Week1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Employee #3[/TD]
[TD]Week1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"].Employee #4[/TD]
[TD]Week1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Employee #5[/TD]
[TD]Week1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Where "FORMULA" is written, is where =INDEX($A$1:$H$15,MATCH($A$18,$A$1:$A$15,0),MATCH(B$18,$B$2:$H$2,0),MATCH($A19,$A$3:$A$15,0))
is.
Any help, or resources will be greatly appreciated! :D
- Problem: Its not printing the correct row of data.
=INDEX($A$1:$H$15,MATCH($A$18,$A$1:$A$15,0),MATCH(B$18,$B$2:$H$2,0),MATCH($A19,$A$3:$A$15,0))
Here is the same formula, which explains the above formula, and what I'm looking to achieve.
=INDEX(Full_Schedule,MATCH(Data_Validation(Week1|Week2),Where_Week1_&_Week2_Are_Found,0),MATCH(Day_Of_The_Week,Where_Day_Of_The_Week_Is_Found_In_Full_Schedule,0),MATCH(Employee_Name,Where_Employee_Name_Is_Found_In_Full_Schedule,0))
Here is the sheet im working with...
[TABLE="width: 0"]
<tbody>[TR]
[TD="align: center"]Week1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SUN[/TD]
[TD]MON[/TD]
[TD]TUE[/TD]
[TD]WED[/TD]
[TD]THUR[/TD]
[TD]FRI[/TD]
[TD]SAT[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #1[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="align: right"]Employee #2[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #3[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="align: right"].Employee #4[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]12:15-6:15[/TD]
[TD="align: center"]12:15-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #5[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]12:15-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]Week2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SUN[/TD]
[TD]MON[/TD]
[TD]TUE[/TD]
[TD]WED[/TD]
[TD]THUR[/TD]
[TD]FRI[/TD]
[TD]SAT[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #1[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="align: right"]Employee #2[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #3[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="align: right"].Employee #4[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]12:15-6:15[/TD]
[TD="align: center"]12:15-6:15[/TD]
[TD="align: center"]9:45-6:15[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #5[/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]12:15-6:15[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[TD="align: center"]9:45-6:15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Week1 v[/TD]
[TD="align: center"]SUN[/TD]
[TD="align: center"]MON[/TD]
[TD="align: center"]TUE[/TD]
[TD="align: center"]WED[/TD]
[TD="align: center"]THUR[/TD]
[TD="align: center"]FRI[/TD]
[TD="align: center"]SAT[/TD]
[/TR]
[TR]
[TD="align: right"]Employee #1[/TD]
[TD]FORMULA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Employee #2[/TD]
[TD]Week1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Employee #3[/TD]
[TD]Week1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"].Employee #4[/TD]
[TD]Week1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Employee #5[/TD]
[TD]Week1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Where "FORMULA" is written, is where =INDEX($A$1:$H$15,MATCH($A$18,$A$1:$A$15,0),MATCH(B$18,$B$2:$H$2,0),MATCH($A19,$A$3:$A$15,0))
is.
Any help, or resources will be greatly appreciated! :D
Last edited: