It can be hard, especially with large ranges of cells, to memorize the exact locations, especially when they're used in many different formulas and functions. Using a Range Name can be helpful. We will have a situation where this makes things much easier. The LOOKUP Function in Excel gives users the ability to take data from a table and use it.