Hey Kam, sure thing! :)
To look up multiple columns in another table based on multiple criteria such as domain AND city or domain AND zip code, you can use the "Lookup Multiple Rows in Other Table" action in Clay. This feature allows you to retrieve multiple matching records from another table by specifying the criteria you need. For instance, you can match companies in one table with another using both domain and city or domain and zip code as your criteria. Here's how you can set it up:
* Identify the ID of the table you want to search.
* Use dynamic fields to specify the criteria for matching the records, such as domain and city or domain and zip code.
* Run the lookup action to retrieve the matching rows from the other table.
Hope this helps! :)
.png){kind=logo}
