named data ranges

classic Classic list List threaded Threaded
1 message Options
Gary Collins Gary Collins
Reply | Threaded
Open this post in threaded view

named data ranges

Hello again
I appear to be experiencing a problem with named data ranges lo x64 win 7.

Q. Is it possible and permissible to define overlapping data ranges? I want a range named mdec which will be A1:B25 and another xlit B1:C25 (the col B values are common) to use in lookups.

I have set them up and they appear ok in the Define Database Range dialog. However, when i try to enter xlit as the range in a formula i find that it automatically gets changed to mdec.

Im going now to try with the ranges defined explicitly instead of using the names, but i wonder if this problem sounds at all familiar to anyone, and if theres anything i can do about it?


To unsubscribe e-mail to: [hidden email]
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted