There isn’t an INDEX / MATCH equivalent in Airtable. Airtable is a database, so cells don’t have the kind of horizontal/vertical spatial relationship to each other that they have in Excel. Formula’s in Airtable don’t refer to cells, they refer to fields.
I’d love to know the answer as well. In my case, I have an external-facing and internal-facing table. I want the external table to just be a subset of the internal table (fewer columns), but want it to automatically pull the table contents in for select columns based on the same primary fields between the two tables, instead of just copy-pasting. In excel, you would just index-match based on the primary fields - any way to do it on Airtable?
I'd like to be able to add a new third column to Table 1, which would 'look up' the "Description" of that location (from Table 2) based on the postcode (from Table 2).
I think the 'obvious' solution might be to change Table 2's primary field to 'Postcode, and then a more straightforward linked table relationship would be fine. However, this field also gets linked elsewhere in other parts of the base and so it's not an option to switch those primary fields.