INDEX help

[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

 

[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)