Lookup & Reference Functions
VLOOKUP, XLOOKUP, INDEX/MATCH, FILTER, SORT and UNIQUE. Each function below has a side-by-side syntax table for Excel, Google Sheets, Airtable and Notion, a live tester, and one-click copy buttons.
| Function | What it does | Excel | Google Sheets | Airtable | Notion |
|---|---|---|---|---|---|
| VLOOKUP | Find a value in the first column and return one from the same row | ✔ | ✔ | ✘ | ≈ |
| XLOOKUP | Modern lookup: exact by default, looks left, built-in not-found value | ✔ | ✔ | ✘ | ≈ |
| INDEX | Return the value at a given row and column of a range | ✔ | ✔ | ✘ | ≈ |
| MATCH | Find the position of a value in a row or column | ✔ | ✔ | ✘ | ≈ |
| INDEX + MATCH | Flexible lookup that can look left and survives inserted columns | ✔ | ✔ | ✘ | ≈ |
| CHOOSE | Pick a value from a list by its position number | ✔ | ✔ | ≈ | ≈ |
| FILTER | Return only the rows that meet a condition | ✔ | ✔ | ✘ | ✔ |
| UNIQUE | List the distinct values in a range, removing duplicates | ✔ | ✔ | ≈ | ✔ |
| SORT | Return a range sorted by one of its columns | ✔ | ✔ | ✘ | ≈ |
✔ built-in function ≈ works with a workaround formula ✘ not available