Clay Icon

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?

  • Avatar of Channeled
    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

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Mensur! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Thank you so much for sharing your feedback Mensur!