If a cell in table 1 contains text found in table 2, return value(s) in table 2

[Ben_Faust]

“Client Table” contains clients in column A. One client to a row. Each client belongs to a group (Group 1, Group 2, Group 3, etc), which is listed in column B.  

“Project Table” contains projects. The name of each project is in column A. Each project has one or more clients. One project could have clients from multiple groups. 

I’d like a column in the Project Table to list all the groups represented in a project.  

Thanks!

[DisraeliGears01 · Accepted solution]

This is a pretty simple lookup field. Just make the second field in your project table (the one with the clients) a linked record to the client table, and then the third field in the project table is a lookup of group field in the client table. 

[TheTimeSavingCo · Accepted solution]

Depending on how your data's set up a lookup field might end up displaying some duplicates.  If that happens, try creating a rollup field with 'ARRAYUNIQUE':

Link to base