Compare and match 2 columns in 2 different tables

Topic Labels: Formulas
1121 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi everyone,

I have 3 different tables:

  1. prospects (looking for a place)
  2. Landlords (renting a place)
  3. Matching table

On the 1 and 2nd table, I have a column named “type of place” that is a single select option.
People can then fill “House” or “flat” or “shop” for example.

I would like on my 3rd table to be able to indicate in a column if there is a match between the answer of a prospect on table one column “type of place” and a landlord table 2 column “type of place”. I will then have a column : “Name of prospect” + a column “Name of landlord” + a column “Matching place” and the name of the matching criteria (eg: house).

Someone knows how to do that? :slightly_smiling_face:

Thanks a lot!


2 Replies 2
4 - Data Explorer
4 - Data Explorer

Note: table 1 and table 2 are both filled from 2 different forms (one for prospects and one for landlords)

Hi @Alix_Marie ,

Welcome to Airtable Community !

The best way to do that is to have a the Type of Place as a Linked record field where the types of places are in a 4th table. This way you can see the Prospects and landlords based on this Type.

Alternatively, you can use an automation to search for the type in the landlords table when a new record is created un prospects table and vice versa.