Question on LABEL Range
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
|