Basic Summary / List Formula for Lookup Table


Say I have these two tables, “Directory” and “Company”.

Screen Shot 2020-12-22 at 3.46.44 PM
Screen Shot 2020-12-22 at 3.46.59 PM

I’m needing a formula for the Company table’s “Employee Summary” column. I’m just wanting the row to look up and list the employees that are assigned to that company in the “Directory” table (the ‘Coke’ row should list John & Eric, and so on).

I’m driving myself crazy trying to figure this out. Many apologies as I know the answer is bloody simple, but I’ve tried every formula under the sun and can’t get it working.

Thanks a ton.

Is this what you’re looking for?

Here’s a screenshot of where to look:


@Sarah_Arminta Thank you SO MUCH! This is sincerely appreciated. That’s exactly what I needed. Appreciate your time.

I can’t say I fully understand why it works. This is the formula, correct?


Does this formula output employees because that is the display column in the Directory table?

1 Like

Yes, I believe that is correct. So we are filtering the Directory table and spitting out whichever records (employees) have a Company property that matches the Company of our row in the Company table.

1 Like

Great to know. Thanks so much again. Happy Holidays!

1 Like

As always in CODA, there are multiple ways to do this. This one eliminates the need for an extra table: Use the Directory table, and use options to group it on “Company”.