Good one! For that I'd recommend running the Lookup Record before you enrich them, that way you can pull existing info and only enrich those that don't currently exist. Those newly enriched companies, you can write them over to a "master company table" where you pull data from if that helps
Sure! It's as straightforward as it sounds. Once you have a list of companies and the value you want to look up, that's the first step you add, then you snowball the rest of the enrichments giving them the condition to only run if no match is found
Also I want to confirm we're on the same page for my first request. For the first two rows for the company called Activate, the formula cells should read Garry Cooper, Hans Yang for both rows.
Yeah the lookup record is for something else I'm doing. For the formula, we want to lookup duplicate names and then create a comma separated list of the warm connects attached to those names