Lots of moving parts to fill a cell help.

[Ralphie8on]

I have 3 tables I need to connect and return a value into a cell in 1 of the tables.

In 1 table I have a list of names and a number correlated to those names, we can call that table (Names).
In the second table is a list of members of various clubs, we can call that (Clique)
In the third table is where I want to return a value into the "Friends" cells

If the value in Names is >9 then I want to look for that name in Clique and add that name to "Friends" in the appropriate clique row comma separated.

 

[Ralphie8on]

I figured it out, I took the clique table and in each entry put an if statement to determine the rep number from names. If they were at a certain point the name was entered otherwise it was left blank. In the Table i wanted to enter the values I used TEXTJOIN and ignored blanks and everything is just how i want it.