How to Output a Colleague's Name from a Table in Excel

·

Anyone know a way to ouput a colleague name you already have in a table? I have found people from the same company (max 2) and want to add a 'p.s. I emailed {{first_name}} too - but using both forumla and AI, I can't get it to output the name of the colleague in a column, despite the domains being the same

6 comments

Amit S.
·
·
Rollup the names at the company level, then replace the name of the employee.
Jonathan M.
·
·
Amit S. do you have an example of how to do that?
Amit S.
·
·
I don’t. I will have to create something to demonstrate it which will take time.
Faheem G.
·
·
In my opinion add all records into different table then use lookup multiple rows and ask AI to output the name of the second person that is not available at this table.
Jonathan M.
·
·
Amit S. if you could, I would appreciate it
Amit S.
·
·
1.
Old table: Write Company names to a new table
2.
New table: Dedupe company names in the new table
3.
New table: Lookup multiple rows in other table
4.
Old table: Lookup single row in other table
5.
Replace person name from row with null