Named ranges

P

pspkim

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
 
P

Paul Lautman

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
Click to expand...

Take a look at the INDEX function, it does just that.
 
Top