Index function to return entire rows|VBA & Macros|Excel Forum|My Online Training Hub

Hi all,

I've been experimenting with index and match ; INDEX(F5:J16,4,0)

and more important  NDEX(C3:G14,SEQUENCE(ROWS(C3:C14)),0)

The first when using 0 for the column will return the entire row, which is what I want, the second formula returns all the rows which is what I want but only  only returns the first column? and I want them all.

I can use a curly {1,2,3,4 etc} to get all the columns, but this is not great.  nor dynamic.

Please don't suggest filter functions because that's not the point.  I'd like to sovle the problem.

I've attached the workbook I've been using ; sheet 1 better example.

Richard.