Yes, it's possible to perform a lookup from one Clay workbook to another. We offer a Lookup integration that functions similarly to VLOOKUP in spreadsheets, allowing you to pivot data between tables.
There are two main options:
1. Lookup Single Row in Other Table: This action searches for a single row in another Clay table. It's faster but limited to one row.
2. Lookup Multiple Rows in Other Table: This action allows you to find multiple rows in another Clay table based on specified criteria.
Both options require you to specify the table to search, target column, filter operator, and row value. For detailed instructions, you can refer to our documentation on the Clay website.
.png){kind=logo}
