Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Check if column value from one table exists in another table

3424 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Anthony_Lee
4 - Data Explorer
4 - Data Explorer

I have Table A, column 1, with value "hello@world.com"

I want to see if that value also exists in Table B, column 1.

Something like this in Excel:

Is this possible in Airtable?

1 Reply 1

A while back, I posted some data deduplication routines and a document on Google Drive describing their use; you can find the applicable URLs in this reply, with a mention of an improved version a little lower in the thread. If you can wait a few days, I’m in the process of revising the document and sample bases, and I hope to have them online sometime next week.