Pull information from one range, and auto populate specific cells based on multiple criteria.

[BrandonBerner]

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:

�� 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.

What am I doing wrong lol?