Displaying dynamic range values??

R

rpp114

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.
 
D

Domenic

First, change the formula for the reference as follows...

=OFFSET($A$1:$A$150,index_1,index_2,15,1)

Then, select a vertical range consisting of 15 cells. While these cells
are highlighted, enter the following...

=Values

....and confirm with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!
 
Top