Using INDEX function to return array row.
 

I,m trying to use the index function to return an entire row of data from an
array of mixed text and numbers. According to the help system entering the
function without a column reference should return the entire row.

"If array has more than one row and more than one column, and only row_num
or column_num is used, INDEX returns an array of the entire row or column in
array."

I can not make this work. The best I can do is get a single value. Does
anyone have any experience using the INDEX function to return an array row?

Thanks,

Using INDEX function to return array row.
 

Hi,
if using INDEX to return an array (the row is an array), then you need
to enter it as an array formula. For example, if your data has 4
columns, select A20:D20, enter the formula:

=INDEX(A1:D10,2,)

commit with Shift+Ctrl+Enter. Now, all cells A20:D20 will contain the
2nd row of A1:D10.

Does this help?
Kostis Vezerides