+ Reply to Thread
Results 1 to 2 of 2

Named ranges-is there a an easy way to reference a single value in a named range?

  1. #1
    pspkim@gmail.com
    Guest

    Named ranges-is there a an easy way to reference a single value in a named range?

    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


  2. #2
    Paul Lautman
    Guest

    re: Named ranges-is there a an easy way to reference a single value in a named range?

    pspkim@gmail.com wrote:
    > 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


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



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1