Spreadsheet formulas explained, side by side

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.

FunctionWhat it doesExcelGoogle SheetsAirtableNotion
VLOOKUPFind a value in the first column and return one from the same row✔✔✘≈
XLOOKUPModern lookup: exact by default, looks left, built-in not-found value✔✔✘≈
INDEXReturn the value at a given row and column of a range✔✔✘≈
MATCHFind the position of a value in a row or column✔✔✘≈
INDEX + MATCHFlexible lookup that can look left and survives inserted columns✔✔✘≈
CHOOSEPick a value from a list by its position number✔✔≈≈
FILTERReturn only the rows that meet a condition✔✔✘✔
UNIQUEList the distinct values in a range, removing duplicates✔✔≈✔
SORTReturn a range sorted by one of its columns✔✔✘≈

✔ built-in function   ≈ works with a workaround formula   ✘ not available