Skip to main content

Check if column value from one table exists in another table

  • August 9, 2018
  • 1 reply
  • 11 views

Forum|alt.badge.img

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

Forum|alt.badge.img+5
  • Inspiring
  • August 10, 2018

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.