Clay provides a Lookup integration that functions similarly to VLOOKUP in spreadsheets.
For multiple rows, use the "Lookup Multiple Rows in Other Table" action with these inputs:
** Table to Search - Select your target table
** Target Column - Column to search in
** Filter Operator - How to match values
** Row Value - Value to search for
** *Limit (Optional) - Maximum rows to return
This enables you to retrieve multiple matching records from another Clay table based on your specified criteria.
Hi Moritz, thank you for reaching out. I believe that this can be achieved using our Lookup function. This video explains how to set up and use a lookup function in 2 minutes. I suggest using a unique identifier such as LinkedIn URL or company domain in order to find the row you are looking for. Let me know if this helps!