If specific text within multiple ranges, input corresponding cell values

CallMeKris

New Member
Joined
Feb 3, 2021
Messages
6
Office Version
  1. 365
Platform
  1. Windows
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
BCDEFGHIJKLMNOPQRST
52-Mar3-Mar4-Mar5-Mar6-Mar2-Mar3-Mar4-Mar5-Mar6-Mar
6TLSTaskDateTime SlotCompletedTimesMondayTuesdayWednesdayThursdayFridayTimesMondayTuesdayWednesdayThursdayFriday
7Name 13/211:00AM11:00AM
8Name 211:30AMName 111:30AM
9Name 312:00PM12:00PM
10Name 412:30PM12:30PM
11Name 51:00PM1:00PM
12Name 6
13Name 72:00PM2:00PM
14Name 82:30PM2:30PM
15Name 93:00PM3:00PM
16Name 103:30PM3:30PM
17Name 114:00PM4:00PM
18Name 124:30PM4:30PM
19Name 135:00PM5:00PM
205:30PM5:30PM
21
222-Mar3-Mar4-Mar5-Mar6-Mar2-Mar3-Mar4-Mar5-Mar6-Mar
23TimesMondayTuesdayWednesdayThursdayFridayTimesMondayTuesdayWednesdayThursdayFriday
2411:00AM11:00AM
2511:30AM11:30AM
2612:00PM12:00PM
2712:30PM12:30PM
28
292:00PM2:00PM
302:30PM2:30PM
313:00PM3:00PM
323:30PM3:30PM
334:00PM4:00PM
344:30PM4:30PM
355:00PM5:00PM
365:30PM5:30PM
37
382-Mar3-Mar4-Mar5-Mar6-Mar
39TimesMondayTuesdayWednesdayThursdayFriday
4011:00AM
4111:30AM
4212:00PM
4312:30PM
44
452:00PM
462:30PM
473:00PM
483:30PM
494:00PM
504:30PM
515:00PM
525:30PM
Sheet1
Cell Formulas
RangeFormula
D7D7=IF(COUNTIF(I7:I20,"*Name 1*"),I5,"")
Cells with Data Validation
CellAllowCriteria
I7:M11List=$B$7:$B$19
I13:M20List=$B$7:$B$19
P7:T11List=$B$7:$B$19
P13:T20List=$B$7:$B$19
P24:T27List=$B$7:$B$19
P29:T36List=$B$7:$B$19
I24:M27List=$B$7:$B$19
I29:M36List=$B$7:$B$19
I40:M43List=$B$7:$B$19
I45:M52List=$B$7:$B$19
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,136,275
Messages
5,674,782
Members
419,524
Latest member
helensesc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top