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:

[TABLE="width: 0"]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=2F2F2F]#2F2F2F[/URL] , colspan: 9, align: center"]�� WORK SCHEDULE[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFE599]#FFE599[/URL] , align: center"]week01[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: center"]SUN[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: center"]MON[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: center"]TUE[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: center"]WED[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: center"]THUR[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: center"]FRI[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: center"]SAT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: center"]��[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: right"]Ali[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]11:45-5:15[/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]12:15-6:15[/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: right"]Brandon[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]11:45-5:15[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]9:45-6:15[/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]12:15-8:15[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]12:15-8:15[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]9:45-6:15[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: right"]Elysa[/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]9:30-6:15[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]9:45-5:30[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]9:45-5:30[/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: right"]James[/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]5:00-8:00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]9:45-6:15[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: right"]Nick[/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]9:45-5:15[/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]9:45-6:15[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]9:45-5:30[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]9:45-5:30[/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=999999]#999999[/URL] , align: right"]Reub[/TD]
[TD="bgcolor: #CEECFF"]#ERROR![/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E06666]#E06666[/URL] , align: center"]4:00-8:15[/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="bgcolor: #CEECFF"][/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 9"][/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JANUARY[/TD]
[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]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #D9D9D9"]week01[/TD]
[TD="bgcolor: #d9d9d9"][/TD]
[TD="bgcolor: #D9D9D9"]30SUNDAY[/TD]
[TD="bgcolor: #D9D9D9"]31MONDAY[/TD]
[TD="bgcolor: #D9D9D9"]01TUESDAY[/TD]
[TD="bgcolor: #D9D9D9"]02WEDNESDAY[/TD]
[TD="bgcolor: #D9D9D9"]03THURSDAY[/TD]
[TD="bgcolor: #D9D9D9"]04FRIDAY[/TD]
[TD="bgcolor: #D9D9D9"]05SATURDAY[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: #EFEFEF"]reub[/TD]
[TD]VAC reub[/TD]
[TD]VAC reub[/TD]
[TD]NEW reub[/TD]
[TD]VAC reub[/TD]
[TD]4:00-8:15 reub[/TD]
[TD]reub[/TD]
[TD]reub[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: #EFEFEF"]Elysa[/TD]
[TD]Elysa[/TD]
[TD]Elysa[/TD]
[TD]YEAR Elysa[/TD]
[TD]9:30-6:15 Elysa[/TD]
[TD]9:45-5:30 Elysa[/TD]
[TD]9:45-5:30 Elysa[/TD]
[TD]Elysa[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: #EFEFEF"]James[/TD]
[TD]James[/TD]
[TD]James[/TD]
[TD]James[/TD]
[TD]James[/TD]
[TD]- James[/TD]
[TD]5:00-8:00 James[/TD]
[TD]9:45-6:15 James[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: #EFEFEF"]Nick[/TD]
[TD]Nick[/TD]
[TD]9:45-5:15 Nick[/TD]
[TD]NEW Nick[/TD]
[TD]9:45-6:15 Nick[/TD]
[TD]9:45-5:30 Nick[/TD]
[TD]9:45-5:30 Nick[/TD]
[TD]Nick[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: #EFEFEF"]Brandon[/TD]
[TD]11:45-5:15 Brandon[/TD]
[TD]9:45-6:15 Brandon[/TD]
[TD]YOU Brandon[/TD]
[TD]Brandon[/TD]
[TD]12:15-8:15 Brandon[/TD]
[TD]12:15-8:15 Brandon[/TD]
[TD]9:45-6:15 Brandon[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: #EFEFEF"]Ali[/TD]
[TD]11:45-5:15 Ali[/TD]
[TD]Ali[/TD]
[TD]Ali[/TD]
[TD]12:15-6:15 Ali[/TD]
[TD]RDO Ali[/TD]
[TD]Ali[/TD]
[TD]SICK Ali[/TD]
[/TR]
[TR]
[TD="bgcolor: #D9D9D9"]week02[/TD]
[TD="bgcolor: #d9d9d9"][/TD]
[TD="bgcolor: #D9D9D9"]06SUNDAY[/TD]
[TD="bgcolor: #D9D9D9"]07MONDAY[/TD]
[TD="bgcolor: #D9D9D9"]08TUESDAY[/TD]
[TD="bgcolor: #D9D9D9"]09WEDNESDAY[/TD]
[TD="bgcolor: #D9D9D9"]10THURSDAY[/TD]
[TD="bgcolor: #D9D9D9"]11FRIDAY[/TD]
[TD="bgcolor: #D9D9D9"]12SATURDAY[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: #EFEFEF"]reub[/TD]
[TD]reub[/TD]
[TD]reub - 6657[/TD]
[TD]reub - 6657[/TD]
[TD]8:30-4:30 reub[/TD]
[TD]4:15-8:15 reub[/TD]
[TD]4:00-8:15 reub[/TD]
[TD]reub[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: #EFEFEF"]Elysa[/TD]
[TD]Elysa[/TD]
[TD]12:45-6:15 Elysa[/TD]
[TD]9:45-6:15 Elysa[/TD]
[TD]9:45-6:15 Elysa[/TD]
[TD]9:30-5:30 Elysa[/TD]
[TD]9:30-5:30 Elysa[/TD]
[TD]Elysa[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: #EFEFEF"]James[/TD]
[TD]11:45-5:15 James[/TD]
[TD]- James[/TD]
[TD]12:15-6:15 James[/TD]
[TD]- James[/TD]
[TD]- James[/TD]
[TD]- James[/TD]
[TD]9:45-6:15 James[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: #EFEFEF"]Nick[/TD]
[TD]- Nick[/TD]
[TD]- Nick[/TD]
[TD]sick Nick[/TD]
[TD]sick Nick[/TD]
[TD]sick Nick[/TD]
[TD]sick Nick[/TD]
[TD]sick Nick[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: #EFEFEF"]Brandon[/TD]
[TD]RDO Brandon[/TD]
[TD]9:45-6:15 Brandon[/TD]
[TD]Brandon[/TD]
[TD]Brandon[/TD]
[TD]11:00-7:30 Brandon[/TD]
[TD]12:15-8:15 Brandon[/TD]
[TD]Brandon[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="bgcolor: #EFEFEF"]Ali[/TD]
[TD]SICK Ali[/TD]
[TD]9:45-6:15 Ali[/TD]
[TD]Ali[/TD]
[TD]RDO Ali[/TD]
[TD]RDO Ali[/TD]
[TD]9:30-5:30 Ali[/TD]
[TD]9:45-6:15 Ali[/TD]
[/TR]
[/TABLE]

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?