Home
Events
Groups
Members

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

University
Clay live events

Powered by Tightknit

Creating a VLOOKUP Formula to Match Company Names in Excel | Clay

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.

3 comments

· Sorted by Oldest

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 Clay Support.