INDEX help

A

af_jester

how do i get the index to function to work for more than one retur
value.

i.e. if i wanted to index more than one result in the same array ho
do i go about setting up the formulas to display all the result
instead of the first result it comes to.

Chri
 
D

Dave R.

=INDEX(G8:H14,ROW(1:4),1)

you can try an array formula like this, entered in 4 cells at once with CTRL
SHIFT ENTER, and it will return the first 4 rows of the first column of
G8:H14 (g8 through g11)
 
Top