Link formula like Vlookup

Hey all,

I have two tables that I need to link. Table 1 is a table which gets daily new info. In one column, I have to concatenate. This changes daily with the new information and therefore needs to stay as a formula.
In Table 2, I have a sort of database of possible concatenation options with responding values. These two values need to be selected according to the newly created cell in Table 1.
In Excel, this could be quickly done via a Vlookup, but I struggle to do this in Airtable.
Has anyone had a similar problem and can offer a solution? If you need more info, please tell me.

Thank you

Welcome to the community, @Johan_Stubert!

In Airtable, you can’t automatically link tables based on field values nor based on formulas. Airtable requires the human to MANUALLY & EXPLICITLY link records to one another.

This is done by creating a “linked record” field which points to the other table, and then you can MANUALLY choose which record you want to link it to in the other table.

In Airtable, you are always linking to the entire record as a whole based on its PRIMARY FIELD VALUE, never based on any other field values.

And this is always done MANUALLY in Airtable.

There are only 3 exceptions when this linking is done AUTOMATICALLY for you:

Exception #1: If you convert a text field to a “linked record” field, that is one of the few times when Airtable will “automatically” link records between tables for you — as long as the contents of the converted text field match the PRIMARY FIELD VALUE in the other table. But this is just a “one time only” automatic linking during the field conversion process. (Airtable will automatically create records in that other table if your converted value doesn’t match any existing records.)

Exception #2: If you paste (or type) data into a “linked record field” and the value you just pasted exactly matches A PRIMARY FIELD VALUE in the other table. Then, an automatic link will be created to that other record. (Airtable will automatically create records in that other table if your pasted value doesn’t match any existing records.)

Exception #3: If you group all of your records by a “linked record field”, adding a new record to the group will automatically populate the link field with the same value as the group, thus linking you to the same record as the other records in your group.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slight_smile:

1 Like

Thank you, I used a slightly different workaround but your explanation proved to be very helpful in figuring all of this out.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.