Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

How to Reference Values Between Tables in Excel Workbooks | Clay

How to Reference Values Between Tables in Excel Workbooks

·Dec 11, 2024 12:17 PM·

im having two tables in one workbook. Im trying to get a value from table 1 into the table 2. but I can not figure it out. When i type / i only get columns in that same table, not the other one. Any suggestions?

3 comments

· Sorted by Oldest

Channeled
APP
·
·
To transfer data between tables in your workbook, you can use the "Lookup Single Row in Other Table" integration. Here's how: 1. Click "Add Enrichment" in the top right corner of your page 2. Search for and select "Lookup Single Row in Other Table" 3. Select your source table (the table you want to get data from) 4. Map the columns you want to bring over from the source table to your current tableThis is a more efficient method than trying to use the '/' key, which only shows columns within the current table. The Lookup integration is specifically designed for accessing and transferring data between tables in your workbook. Sources: Write to table integration overview | Clay University Lookup Single Row in Other Table with Clay
Channeled
APP
·
·
Hi Mensur! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Mensur!