Check if column value from one table exists in another table

[Anthony_Lee]

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:

stackoverflow.com

Check if an excel cell exists on another worksheet in a column - and return the contents of a differ...

excel, excel-formula, vlookup, excel-match

asked by YelizavetaYR on 01:51PM - 14 Apr 14 UTC

Is this possible in Airtable?

[W_Vann_Hall]

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.