Dynamic List

Hi All,

I'm trying to use a dynamic list and after reading the other solved threads on this same topic I am still having no luck with my problem. It's probably an easy fix that I'm overlooking but I would really appreciate some help.

I'm working with a list that changes based on how what employee works at each service center. I am currently using a data validation list to change the service center (Cell A2 in the example) and I want the employees of that service center only to populate in the next drop down (B2) without returning #N/A. I am using 9 as the number of employees (column H) in the employees tab as 9 is the maximum amount of employee at any service center.

I have tried =offset(countif()) with no luck. I admittedly am not too familiar with these functions so it could easily be an EBKAC error. An example of my problem is attached

Thanks,
T