I have two tables in my worksheet. I did a find companies table and find people table. I'm trying to merge alot of the data from the companies table to the people table. I got most of it, but for some reason, the "Size" (Company size) doesn't show up under the formula?
When you add new columns like "Size" to your company table, you need to re-run the company lookup in your people table to see these new values. This refreshes the connection between tables and makes the new fields available in your formulas. You can rerun the column linked to the company table to refresh the data and pull in the enriched company information, including the Size field.
Yes, we have two ways of doing this: [ 1. **Write to Table::**](https:://www.clay.com/university/lesson/write-to-table-clay-101) You can send data into a new table using the “write to table” option. This is great for sending lists of objects, individual values, or both. For example, if you have an enrichment with a list of multiple objects, you would select the “write to table list” option. You can also add other values to match that are in this table but not as a list. [ 2. **Lookup::**](https:://www.loom.com/share/ad767e3be9914d19a2f6647efe4dfa85?sid=c8b78c32-9bc1-4501-8124-d6c70d2218cf) If you want to add more information that you already found from a previous table to the current data you have (e.g., matching domains), then “lookup” is the best option. This allows you to call matching data into one table. Let me know if that answers your questions. Happy prospecting! 💪✨