Displaying numbers stored in a range???
 

I have selected a dynamic range that is defined similar to Values =
offset(a1:150,index_1,index_2,15,1). I want to display the numbers
saved in the Values range. I can get them to display, but when they do
they only appear in the cooresponding row that is looked up. How can I
show the values of the range, where no matter the first value of it, it
will show up in a defined cell?

Basically, I want the numbers stored in the Values range to display in
a1:a15 no matter what the vertical offset is.

If this makes sense thanks, if not I will attempt to clarify.


--
rpp114
------------------------------------------------------------------------
rpp114's Profile: http://www.excelforum.com/member.php...o&userid=34131
View this thread: http://www.excelforum.com/showthread...hreadid=539009