Creating a VLOOKUP Formula to Match Company Names in Excel

Stephane R. · 2025-03-04T19:00:01.922189+00:00

Hi team, I am struggling to build a formula that tells me if the company in the current table can also be found in another table in the workbook (a simple vlookup). If yes, d like it to return "yes", if no, "no". Have been trying the AI prompt and chatgpt, nothing works.

To check if a company in your current table exists in another table and return "yes" or "no", you can use our "Lookup Single Row in Other Table" integration. Here's how: 1. Add a new column to your current table. 2. Click "Add Enrichment" and search for "Lookup Single Row in Other Table". 3. Select the table you want to search in. 4. Choose the column to match (e.g., company name or domain). 5. In the formula section, use an IF statement: =IF(ISNOTEMPTY([Lookup Result]), "yes", "no") This will return "yes" if the company is found, and "no" if it's not. If you need further assistance, please let me know.

Source: Lookup Single Row in Other Table with Clay

3 comments