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?
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! 💪✨
