If the range is named Months, you can use the INDEX function to get the
fourth item. For example: =INDEX(Months,4)

Sarah Tanembaum wrote:
In a LABEL Range(say that it has 12 elements row-wise), how do one refer
to the 4th elements?

I have this ideas that in a worksheet, I have 12 rows single column
LABELED range called MONTHS, where 1st elements is JAN(that is C6), and
so on, and last element would be DEC(C17).

How do I get the 4th element which will be APR, and put that value in
the different cell using the LABEL reference instead of the absolute
cell location(C9)?

Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html