Dynamic name over multiple separated columns

[andydtaylor]

Hi,

I know I can do this as a name:

=Sheet2!$A:$A,Sheet2!$D:$D,Sheet2!$G:$G,Sheet2!$J:$J

But is something like the following possible?

=OFFSET(INDIRECT(Calcs_Product_IDs!$A:$2,Calcs_Product_IDs!$D:$2,Calcs_Product_IDs!$G:$2,Calcs_Product_IDs!$J:$2),0,0,(COUNTA(INDIRECT("Product_IDs!$A:$A"))-1))

Thanka,

Andrew

 

[Andrew Poulsom]

More like:

=OFFSET(Sheet2!$A$2,0,0,COUNTA(Sheet2!$A:$A)-1,1),OFFSET(Sheet2!$D$2,0,0,COUNTA(Sheet2!$A:$A)-1,1),OFFSET(Sheet2!$G$2,0,0,COUNTA(Sheet2!$A:$A)-1,1),OFFSET(Sheet2!$J$2,0,0,COUNTA(Sheet2!$A:$A)-1,1)