You can have named ranges in Excel - in fact, you can have named ranges which are dynamically calculated based on a formula.