Creating a VLOOKUP Formula to Match Company Names in Excel

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.

👀1

3 comments

Channeled
APP
·
·
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
Channeled
APP
·
·
Is that what you were looking for?
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.