Extracting data based on drop down list

[AWOLTY]

I have a work schedule, it is broken into two weeks spans with 23 individuals. They reside in different cities. I would like to be able to filter the data based on the city using a drop down list. I have the list created, I have three helper columns that break down the information. When I try to extract the information into a new column, only the first column of data comes in.

 

[Logit]

.
You really should post your workbook on a cloud site (example : DropBox.com) so we can see what you are working with.

Don't include sensitive information.