Add Two Lookup Conditions for Conditional Outputs in Excel

Unfortunately, you can't directly add two lookup conditions in a single lookup operation. The lookup function in Clay only allows filtering based on one column at a time. However, there's a workaround you can use: 1. Create a boolean column in your source table that checks if both conditions are met. 2. Use this boolean column as the condition for your lookup. Here's how to set it up: 1. In the source table, create a new column with a formula that returns true when both conditions are met. 2. In your target table, set up your lookup to filter based on this new boolean column. This approach ensures that the lookup only returns results when both of your original conditions are satisfied. If you need more detailed guidance on implementing this, let me know and I'll be happy to help further.

Source: Getting Estimated Ads Across Platforms and Automating Google Transparency | Clay