Hi, is there a an easy way to reference a single value in a named
range?
For example, if I named a range "Gross_Revenues" - is it possible to
access the first cell of that range by using, for example,
=Gross_Revenues[1] ? It would be even better if I could type
=Gross_Revenues[1999], etc.
Essentially, I'm trying to figure out how to use Named Ranges as arrays
or hashes.
Thanks,
pete
Bookmarks