BrandonBerner
New Member
- Joined
- Mar 16, 2019
- Messages
- 15
Hey there!
So...my boss creates these very confusing and messy schedules. I would like to make a auto-populated streamlined version of his schedule.
Here is a link to my worksheet (its just a dummy containing no personal information):
https://docs.google.com/spreadsheets/d/18GYW9ruWMnCSo-Q9jeXGc2qOWNzZNSXFeb3GFgbWNoQ/edit?usp=sharing
Here is the same sheet pasted here in case you dont want to click the link:
As you can see, my streamlined schedule is in range A1:I8, and my bosses schedule is A14:I27.
I have tried something along the lines of...
=IFERROR(INDEX(!$C$15:$I$27,MATCH($A$2,$A3,0)),"")
Here is the logic...
What am I doing wrong lol?
So...my boss creates these very confusing and messy schedules. I would like to make a auto-populated streamlined version of his schedule.
Here is a link to my worksheet (its just a dummy containing no personal information):
https://docs.google.com/spreadsheets/d/18GYW9ruWMnCSo-Q9jeXGc2qOWNzZNSXFeb3GFgbWNoQ/edit?usp=sharing
Here is the same sheet pasted here in case you dont want to click the link:
�� WORK SCHEDULE | ||||||||
week01 | SUN | MON | TUE | WED | THUR | FRI | SAT | �� |
Ali | 11:45-5:15 | 12:15-6:15 | FALSE | |||||
Brandon | 11:45-5:15 | 9:45-6:15 | 12:15-8:15 | 12:15-8:15 | 9:45-6:15 | TRUE | ||
Elysa | 9:30-6:15 | 9:45-5:30 | 9:45-5:30 | FALSE | ||||
James | 5:00-8:00 | 9:45-6:15 | FALSE | |||||
Nick | 9:45-5:15 | 9:45-6:15 | 9:45-5:30 | 9:45-5:30 | FALSE | |||
Reub | #ERROR! | 4:00-8:15 | FALSE | |||||
9 | ||||||||
JANUARY | ||||||||
week01 | 30SUNDAY | 31MONDAY | 01TUESDAY | 02WEDNESDAY | 03THURSDAY | 04FRIDAY | 05SATURDAY | |
reub | VAC reub | VAC reub | NEW reub | VAC reub | 4:00-8:15 reub | reub | reub | |
Elysa | Elysa | Elysa | YEAR Elysa | 9:30-6:15 Elysa | 9:45-5:30 Elysa | 9:45-5:30 Elysa | Elysa | |
James | James | James | James | James | - James | 5:00-8:00 James | 9:45-6:15 James | |
Nick | Nick | 9:45-5:15 Nick | NEW Nick | 9:45-6:15 Nick | 9:45-5:30 Nick | 9:45-5:30 Nick | Nick | |
Brandon | 11:45-5:15 Brandon | 9:45-6:15 Brandon | YOU Brandon | Brandon | 12:15-8:15 Brandon | 12:15-8:15 Brandon | 9:45-6:15 Brandon | |
Ali | 11:45-5:15 Ali | Ali | Ali | 12:15-6:15 Ali | RDO Ali | Ali | SICK Ali | |
week02 | 06SUNDAY | 07MONDAY | 08TUESDAY | 09WEDNESDAY | 10THURSDAY | 11FRIDAY | 12SATURDAY | |
reub | reub | reub - 6657 | reub - 6657 | 8:30-4:30 reub | 4:15-8:15 reub | 4:00-8:15 reub | reub | |
Elysa | Elysa | 12:45-6:15 Elysa | 9:45-6:15 Elysa | 9:45-6:15 Elysa | 9:30-5:30 Elysa | 9:30-5:30 Elysa | Elysa | |
James | 11:45-5:15 James | - James | 12:15-6:15 James | - James | - James | - James | 9:45-6:15 James | |
Nick | - Nick | - Nick | sick Nick | sick Nick | sick Nick | sick Nick | sick Nick | |
Brandon | RDO Brandon | 9:45-6:15 Brandon | Brandon | Brandon | 11:00-7:30 Brandon | 12:15-8:15 Brandon | Brandon | |
Ali | SICK Ali | 9:45-6:15 Ali | Ali | RDO Ali | RDO Ali | 9:30-5:30 Ali | 9:45-6:15 Ali |
As you can see, my streamlined schedule is in range A1:I8, and my bosses schedule is A14:I27.
- I would like my streamlined schedule to pull the correct times for each employee and auto-populate my schedule if that makes sense.
I have tried something along the lines of...
=IFERROR(INDEX(!$C$15:$I$27,MATCH($A$2,$A3,0)),"")
Here is the logic...
- IF A2 = Week01
- Find "Week01", A11:A27
- Lookup name in range A3:A8
- Match with week01 + Match name.
- Lookup name in range A3:A8
- Find "Week01", A11:A27
What am I doing wrong lol?
Last edited: