Excel - INDEX / MATCH equivalent

What is the excel index match equivalent in a table?

1 Like

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.

Jeremy’s explanation is correct. What are you trying to accomplish with INDEX/MATCH?

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?

Well in your case its advised to just make a new view with certain columns hidden. Making a new table seems extraneous.

But to JWC’s point, can you have an external view that only allows certain parties to see that view and how do I link it to the base data tab so it updates as the underlying data does?

You can share a particular view via a link, anyone with that link can view it:

Views don’t require any maintenance to remain updated, they always show live data.