Functions Lookup Copy page Copy as markdownThe page as text, ready for a chat View as markdown/docs/functions/lookup-functions.md Ask Claude about this pageOpens Claude with this page's address Find a value in a range and return a related one. FunctionWhat it does ADDRESS Returns a cell address as text from row and column numbers. AREAS Returns the number of areas in a reference. HLOOKUP Searches first row and returns matching value. HYPERLINK The text a link displays: clickability is the renderer's. INDEX Returns value at row and column in range. INDIRECT Returns reference specified by text string. LOOKUP Looks up value in one-row or one-column range. MATCH Returns position of value in a range. OFFSET Returns reference offset from starting point. ROW Returns row number of a reference. ROWS Returns number of rows in a reference. VLOOKUP Looks up value in first column of range and returns value from specified column. XLOOKUP Searches range and returns matching item. XMATCH Returns the position of an item in a range or array.
