INDEX help

  • Thread starter Thread starter af_jester
  • Start date Start date
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
 
=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)
 
Back
Top