Return value from another cell when value(s) is present as part of a string

[Georgez]

Hello Experts.
I appreciate any help you can provide. I am trying to list users Secretaries in a spreadsheet
I have a spreadsheet containing user information (initials, name, title etc). If the user is a Secretary, their title includes the initials of the people they work for separated by a comma.
I need to generate the Secretaries initials against the users based on the presence of the users initials in the Secretaries titles. NB some users have more than one secretary.
I am able to use INDEX / MATCH but can't work out how to do this in this scenario, when the users initials are part of a string, and have possible multiple matches.
I have attached an image of some dummy records to illustrate. I am trying to generate the information held in column G.
Many thanks for any guidance.

 

[Georgez]

I have one more question using the same example if I may... Is it possible to return the PA's name held in column D where there are multiple entries? I can use the following against the results generated using the above formula

=INDEX(D:D,MATCH(G2,A:A,0))

but this won't work where there are two PAs. Is there an easy way to do this? And apologies for asking an additional question on a solved post.

 

[Fluff]

How about

=TEXTJOIN(" / ",TRUE,FILTER($D$2:$D$9,ISNUMBER(SEARCH(" "&A2&","," "&$F$2:$F$9&",")),""))

 

[Georgez]

Many thanks @Fluff . This is perfect. I appreciate everyone's assistance

 

[Fluff]

Glad we could help & thanks for the feedback.