### 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 | (Office 365) The array of 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 text string of the contents of a given cell reference. |

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 | (365 Insiders) The value from a cell range which is the intersection of a row OR a column. |

SORT | (365 Insiders) The array of data in a range that has been sorted. |

SORTBY | (365 Insiders) The array of data in a range that has been sorted and satisfies multiple conditions. |

TRANSPOSE | The array with its orientation changed. |

UNIQUE | (365 Insiders) 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 | (365 Insiders) The value in the same row after finding a matching value in any column. |

XMATCH | (365 Insiders) 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(Office 365) The array of 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 text string of the contents of a given cell reference. |

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(365 Insiders) The value from a cell range which is the intersection of a row OR a column. |

SORT(365 Insiders) The array of data in a range that has been sorted. |

SORTBY(365 Insiders) The array of data in a range that has been sorted and satisfies multiple conditions. |

TRANSPOSEThe array with its orientation changed. |

UNIQUE(365 Insiders) 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(365 Insiders) The value in the same row after finding a matching value in any column. |

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

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