Pull Data into Table Based on Matching Company Domain in Excel

i have a find jobs table and a find people table in the same workbook. I want to pull data from a certain cell and insert it into a row in one table based on if the company domain matches between the two tables

3 comments

Channeled
APP
·
·
To pull data from a cell and insert it into a row in one table based on matching company domains between two tables in the same workbook, you can use our "write to table" feature. Here's how: 1. In your workbook, locate the two tables you want to work with. 2. Use the "write to table" integration to transfer data between the tables. 3. Select your Clay account and choose the destination table. 4. Pick the column containing the company domains you want to match. 5. Map the data you want to transfer to the appropriate columns in the destination table. 6. (Optional) Set up auto-update and conditional run settings if needed. This process will allow you to pull data from one table and insert it into another based on matching company domains.
Sources: Write to Other Table | Documentation | Clay University Find People [Clay 101] - Clay University
Channeled
APP
·
·
Did that answer your question?
Stefano
·
·
Hi Miguel, thank you for reaching out. I believe that this can be achieved using our Lookup function. This video explains how to set up and use a lookup function in 2 minutes. I suggest using a unique identifier such as LinkedIn URL or company domain in order to find the row you are looking for. Let me know if this helps!