

HLOOKUP Range Lookup Table with Absolute References
Roman Kondtratiuk
You can use range names in formula and function calculations or to instantly select a pre-defined range of cells. Using range names can also simplify calculations by replacing absolute references.

