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.
You need an array for the columns too, so you could use another SEQUENCE function.
Thanks I'll try that.
RD
I'm assuming there is more to this question because if you want all the rows and all the columns, you don't need INDEX at all: just use =C3:G14
