# Lookup & Reference Functions

ADDRESS | The cell reference given a row and column number. |

AREAS | The number of areas in a cell range or reference. |

CHOOSE | The value in a row (or column) based on an index number. |

COLUMN | The column number of a cell reference. |

COLUMNS | The number of columns in a cell range or reference. |

FILTER | (2021) The array after filtering data in a range that satisfies multiple conditions. |

FORMULATEXT | (2013) The formula from a particular cell. |

GETPIVOTDATA | The data obtained from a pivot table. |

HLOOKUP | The value in the same column after finding a matching value in the first row. |

HYPERLINK | The hyperlink linked to a cell, document or webpage. |

INDEX | The value from a cell range which is the intersection of a row AND a column. |

INDIRECT | The value of a given cell reference specified by a text string. |

LET | (2021) The result of a formula that can use variables. |

LOOKUP | The value in a row (or column) that matches a value in a column (or row). |

MATCH | The position of a value in a list, table or cell range. |

OFFSET | The value in a cell which is an offset from another cell. |

ROW | The row number of a cell reference. |

ROWS | The number of rows in a cell range or reference. |

RTD | The real time data from a program that supports COM. |

SINGLE | (2021, Removed in 365) The value from a cell range which is the intersection of a row OR a column. |

SORT | (2021) The array of data in a range that has been sorted by one column. |

SORTBY | (2021) The array of data in a range that has been sorted based on multiple columns or values in a range. |

STOCKHISTORY | (Microsoft 365) The historical data about a financial instrument. |

TRANSPOSE | The array with its orientation changed. |

UNIQUE | (2021) The array of unique values in a list, table or cell range. |

VLOOKUP | The value in the same row after finding a matching value in the first column. |

XLOOKUP | (2021) The value in the same row after finding a matching value in any column. |

XMATCH | (2021) The position of a value in a list, table or cell range. |

ADDRESSThe cell reference given a row and column number. |

AREASThe number of areas in a cell range or reference. |

CHOOSEThe value in a row (or column) based on an index number. |

COLUMNThe column number of a cell reference. |

COLUMNSThe number of columns in a cell range or reference. |

FILTER(2021) The array after filtering data in a range that satisfies multiple conditions. |

FORMULATEXT(2013) The formula from a particular cell. |

GETPIVOTDATAThe data obtained from a pivot table. |

HLOOKUPThe value in the same column after finding a matching value in the first row. |

HYPERLINKThe hyperlink linked to a cell, document or webpage. |

INDEXThe value from a cell range which is the intersection of a row AND a column. |

INDIRECTThe value of a given cell reference specified by a text string. |

LET(2021) The result of a formula that can use variables. |

LOOKUPThe value in a row (or column) that matches a value in a column (or row). |

MATCHThe position of a value in a list, table or cell range. |

OFFSETThe value in a cell which is an offset from another cell. |

ROWThe row number of a cell reference. |

ROWSThe number of rows in a cell range or reference. |

RTDThe real time data from a program that supports COM. |

SINGLE(2021, Removed in 365) The value from a cell range which is the intersection of a row OR a column. |

SORT(2021) The array of data in a range that has been sorted by one column. |

SORTBY(2021) The array of data in a range that has been sorted based on multiple columns or values in a range. |

STOCKHISTORY(Microsoft 365) The historical data about a financial instrument. |

TRANSPOSEThe array with its orientation changed. |

UNIQUE(2021) The array of unique values in a list, table or cell range. |

VLOOKUPThe value in the same row after finding a matching value in the first column. |

XLOOKUP(2021) The value in the same row after finding a matching value in any column. |

XMATCH(2021) The position of a value in a list, table or cell range. |

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top