Lookup & Reference Functions |
Description |
---|---|

ADDRESS | Returns the address of a cell in a worksheet, given specified row and column numbers. |

AREAS | Returns the number of areas in a reference. The reference can include a single cell, a range of contiguous cells, or a range of non-contiguous cells. |

CHOOSE | Determines which value from a list of values is to be retrieved based on its position in the list |

Column and Row Functions | |

COLUMN | Returns a Number Rounded away from Zero to the Nearest Multiple of significance |

COLUMNS | Rounds a number down toward zero to the nearest multiple of significance |

ROW | Rounds a number down to the nearest integer |

ROWS | Rounds a decimal number away from zero to the nearest even integer |

ODD | Rounds a decimal number away from zero to the nearest odd integer |

OFFSET | Rounds a number to a specified number of digits |

TRANSPOSE | Always rounds a number down |

Search Functions | |

INDEX | Used to retrieve the value from a single row or the value from any two-dimensional range. It doesn't use a lookup value it just retrieves the value from the specified location. |

LOOKUP | Searches a single row or column for a value and then returns a value from the same position in another single row or column range. |

HLOOKUP | Horizontal Lookup. Uses a lookup value to search the top row of a table or array for a matching value then returns the value from the same column as the row you specify. |

VLOOKUP | Least Common Multiple (Returns the least common multiple of integers) |

MATCH | Returns the result of a number raised to a power |