Hi All!
Does anyone know how I can use a lookup formula to reference previously enriched company data?
I have duplicate company rows in my table because each row represents a different partner at the same company. I want to keep all these rows (since the partners differ), but I don't want to re-run enrichments and spend additional credits on companies I've already enriched.
I understand I should use a lookup formula to reference data from the first instance of each company, but I'm not sure how to actually set this up. For example, if I've already enriched company information in row 1, how do I create a formula in subsequent rows with the same company name to pull that data automatically?
Any guidance would be helpful!
