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

Using VLOOKUP in Clay Tables to Look Up Data Across Tables | Clay

Using VLOOKUP in Clay Tables to Look Up Data Across Tables

·Jan 14, 2025 10:15 PM·

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?

2 comments

· Sorted by Oldest

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
Channeled
APP
·
·
Hi Kaushik K.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: