I'm having problems with my data validation drop down selection populating a row of data

Hi Everyone,

I'm brand new to this thread and I can only imagine how many times this has been answered but I am banging my head against the wall on this one.

Essentially, I am creating a work schedule for employees, so that when you select a certain shift time from the data validation drop down, the shift "block" will populate in the same row right next to it. I'm an excel newbie, so I've read up on VLOOKUP and INDEX Match and I'm just at a complete loss at what to use.

I've attached the best example of what I'm trying to do that I could come up with. Please let me know if I need to provide any more information.

I truly appreciate any help.

Thank you,
gobeavs

This is my first time answering a question, so sorry if I make a mistake.

I found a way to solve it using an Index/Match combination. However, I had to delete the empty cells in your table. Even though it looked like the cells were empty, there was still a value in them. Let me know if this helps.

Thank you! I got it to finally work!

I just had one more question. As you can see the shifts had color attached to them, and I have a count color formula set up and I need the color to travel along with the data. Is this going to be possible at all?

Thanks again!!