Clay Icon

Using VLOOKUP in Clay Tables to Look Up Data Across Tables

ยท
ยท

how to lookup for data in different clay tables? is there something like a vlookup in clay where i can check for a particular value and extract the data from a corresponding column from a different clay table into the main table?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Yes, you can look up data across different Clay tables using two main options:1. "Lookup Single Row in Other Table" - Use this when you need to find and extract data from one matching row. This is the most efficient option for single-row lookups. 2. "Lookup Multiple Rows in Other Table" - Use this when you need to find multiple matching records from another table.These functions work similarly to VLOOKUP, allowing you to extract corresponding values from other tables. For example, when working with companies and people data, the tables are automatically linked, and you can extract specific variables from your companies table into your people table using the Lookup Single Row feature. Sources: Lookup Single Row in Other Table with Clay Lookup Multiple Rows in Other Table with Clay Find People [Clay 101] - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

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