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,