How to Reference Values Between Tables in Excel Workbooks

·

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

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!