Say I have these two tables, “Directory” and “Company”.
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.