Using INDEX function to return array row.

[Guest]

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,

 

[vezerid]

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 A2020, enter the formula:

=INDEX(A110,2,)

commit with Shift+Ctrl+Enter. Now, all cells A2020 will contain the
2nd row of A110.

Does this help?
Kostis Vezerides