Spreadsheet: 220375d1363133820-im-having-problems-with-my-data-validation-drop-down-selection-populating-a-row-of-data-scheduleexample
Sheet: Sheet3

05:00 am to 2:00 pm (Lunch - 9:30, Br - 7:30/12:00) |  |  | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00
05:00 am to 2:00 pm (Lunch - 9:30, Br - 7:15/12:00) |  |  | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:15:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00
05:00 am to 2:00 pm (Lunch - 9:30, Br - 7:30/12:30) |  |  | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00
06:00 am to 2:30 pm (Lunch - 10:30, [NAME]) |  |  |  |  | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00
06:00 am to 3:00 pm (Lunch - 10:00, Br - 8:00/13:00) |  |  |  |  | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00
06:00 am to 3:00 pm (Lunch - 10:00, Br - 8:15/13:15) |  |  |  |  | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:15:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:15:00 | 13:30:00 | 14:00:00 | 14:30:00
06:00 am to 3:00 pm (Lunch - 10:30, Br - 8:15/13:15) |  |  |  |  | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:15:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:15:00 | 13:30:00 | 14:00:00 | 14:30:00
07:00 am to 3:30 pm (Lunch - 10:30, Br - 8:30/13:30) |  |  |  |  |  |  | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00
07:00 am to 4:00 pm (Lunch - 11:00, [NAME]) |  |  |  |  |  |  | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00
07:00 am to 4:00 pm (Lunch - 11:00, [NAME]) |  |  |  |  |  |  | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00
Employee | Shift |  | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00
[NAME] | 05:00 am to 2:00 pm (Lunch - 9:30, Br - 7:30/12:30)
[NAME] | 06:00 am to 2:30 pm (Lunch - 10:30, [NAME])
[NAME] | 07:00 am to 4:00 pm (Lunch - 11:00, [NAME])
 |  | Trying to figure out what
 |  | what formula to use so when you select a certain shift, the corresponding time block will populate the row next it.
 |  | For example, when you select "5:00 am to 2:00 pm (Lunch - 9:30, Br - 7:30/12:30)" in cell B16, how can you pull D4:Y2 to populate D16:Y16?