When you create range names use upper and lower case lettering. For example, rngDataEntry. Excel remembers the upper and lower cases.
When you enter a range name in a formula, enter it as lower case, for example, rngdataentry. After you press Enter Excel will change the cases to match the original definition. In this case, rngDataEntry. If the cases don’t change, then you know you’ve mistyped or haven’t created the range name.
Related content are,