#define names

Naming Cells in Formulas and Functions of Excel

To make it easier to follow your functions you might like to create Range Name. Names that represent a range of cells then use that name in your function. Like the Table components of the VLOOKUP Function.

Using Range Names in Microsoft Excel will make it more efficient to navigate an Excel Workbook, but best of all use a Range Name in a function in place of the Cell References. What this does…