I have a named range. When I assign it to a formula, the address is displayed in the formula, not the range name. Is there a way to correct this so that the descriptive range name appears in the formula. See vlookujp formulae in attached workbook. In the name manager, the cells have the proper notation.