I am faced with the following problem:
I want to pull data from a different table when the status in each table is the same.
I am creating a text.
Say the status in Table 1 is "First Text" then it should check in Table 2 for the row named "First Text" and pull the information from a specific cell in that roll.
In sheets it looks like this: =IF(A4=Table2!A2;Table2!B2;IF(A4=Table2!A3;Table2!B3);0)
How can I replicate that in Airtable?