If specific text within multiple ranges, input corresponding cell values

[CallMeKris]

Hello!

I'm trying to set up a monthly sign up sheet for my work. The people who will be using it have a tendency to break excel files so I want to keep what they can do limited to just selecting options from drop down menus. On the weekly tables, they will select their name from the list for which day and time works for them and what I want to happen is the date and time slot they chose to then be displayed in the blue table. I've tried a few various IF formulas but I'm no pro by any means and all my googling hasn't gotten me anywhere.

If this is even possible, I'd appreciate any advice. If not, then I appreciate the assistance none the less!

Slot Sign Up.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
5								2-Mar	3-Mar	4-Mar	5-Mar	6-Mar			2-Mar	3-Mar	4-Mar	5-Mar	6-Mar
6	TLS	Task	Date	Time Slot	Completed		Times	Monday	Tuesday	Wednesday	Thursday	Friday		Times	Monday	Tuesday	Wednesday	Thursday	Friday
7	Name 1		3/2				11:00AM							11:00AM
8	Name 2						11:30AM	Name 1						11:30AM
9	Name 3						12:00PM							12:00PM
10	Name 4						12:30PM							12:30PM
11	Name 5						1:00PM							1:00PM
12	Name 6
13	Name 7						2:00PM							2:00PM
14	Name 8						2:30PM							2:30PM
15	Name 9						3:00PM							3:00PM
16	Name 10						3:30PM							3:30PM
17	Name 11						4:00PM							4:00PM
18	Name 12						4:30PM							4:30PM
19	Name 13						5:00PM							5:00PM
20							5:30PM							5:30PM
21
22								2-Mar	3-Mar	4-Mar	5-Mar	6-Mar			2-Mar	3-Mar	4-Mar	5-Mar	6-Mar
23							Times	Monday	Tuesday	Wednesday	Thursday	Friday		Times	Monday	Tuesday	Wednesday	Thursday	Friday
24							11:00AM							11:00AM
25							11:30AM							11:30AM
26							12:00PM							12:00PM
27							12:30PM							12:30PM
28
29							2:00PM							2:00PM
30							2:30PM							2:30PM
31							3:00PM							3:00PM
32							3:30PM							3:30PM
33							4:00PM							4:00PM
34							4:30PM							4:30PM
35							5:00PM							5:00PM
36							5:30PM							5:30PM
37
38								2-Mar	3-Mar	4-Mar	5-Mar	6-Mar
39							Times	Monday	Tuesday	Wednesday	Thursday	Friday
40							11:00AM
41							11:30AM
42							12:00PM
43							12:30PM
44
45							2:00PM
46							2:30PM
47							3:00PM
48							3:30PM
49							4:00PM
50							4:30PM
51							5:00PM
52							5:30PM
Sheet1

Cell Formulas
Range	Formula
D7	D7	=IF(COUNTIF(I7:I20,"*Name 1*"),I5,"")

Cells with Data Validation
Cell	Allow	Criteria
I7:M11	List	=$B$7:$B$19
I13:M20	List	=$B$7:$B$19
P7:T11	List	=$B$7:$B$19
P13:T20	List	=$B$7:$B$19
P24:T27	List	=$B$7:$B$19
P29:T36	List	=$B$7:$B$19
I24:M27	List	=$B$7:$B$19
I29:M36	List	=$B$7:$B$19
I40:M43	List	=$B$7:$B$19
I45:M52	List	=$B$7:$B$19

 

[mamady]

my greatest pleasure dear, anytime