Fetching user IDs

[Jonam711]

Hello - I have base data were there are 2 columns, A - list of services which are handled by employees. B - emp IDs. one employee may have multiple services. Now I have another sheet were I have only the services and I need to get the emp IDs in a row.

 

[awoohaw]

T

Thank you bro that helped perfect!

I'm glad someone got you a solution! But, I'm not sure how that is listing employee IDs in a row for each vendor, they seem to be in columns.