Anwar H.

Sounds Interesting, Hey Matt R., Check DM.

Hey Carl W. You just need to use some specific keywords, and the personal email can be extracted. If you want then I can do it for you just share your table with me.

Can you tell me a bit more about this in DM?

Yes, absolutely you can do this across different tables within the same Excel workbook How it works As long as both tables are in the same workbook (even if they're on different sheets), the formula will work. Example Let’s say Sheet 1 is called Law Firms Sheet 2 is called PVB Customers (Law Firms) In Law Firms!A2 you have a domain (from Competitor 1) You want to check if it appears in columns A–C of PVB Customers (Law Firms) Use this in any empty column on Law Firms sheet excel Ye =IF(COUNTIF('PVB Customers (Law Firms)'!A:C, A2) > 0, "Match", "No Match") Then drag the formula down to apply to the whole column.

Hey, Nicole B. In Law Firms sheet if A2 has the domain from Competitor 1. In a new column, enter this formula

excel

=IF(COUNTIF('PVB Customers (Law Firms)'!A:C, A2) > 0, "Match", "No Match")

Drag down the formula for other rows. This checks if the domain in A2 exists in any of the 3 columns (A to C) of the PVB Customers (Law Firms) sheet.

I can do this for you.

Hunain - I’ve solved this problem. You know, as a GTM Engineer, we always have a solution for every issue.

I faced the exact same issue, I signed up for Clay using my personal email and the account got locked. After that I had to create a new account using a second email. If you have an alternate email, I’d recommend signing up with that instead