is it possible for indirect function to reference another sheet any table by cell address?
I wish to skip manually renaming Table when sheet already suffice for viewing multiple sheets.
alternatively is it possible for formula to rename table if sheet is renamed?
Yes you can build your address based on sheet and table name
This sheet contains the data that I will retrieve
And this sheet will show the result
As soon as I change the table name it will pull the data from the other table
Formula for cell B5: INDIRECT(CONCATENATE(B2,"::",ADDRESS(2,2,1,FALSE,B3)),FALSE)
Based on your region the , or the ; will be used to separate the different sections of a formula.
Hope this will help
Ralf
Yes you can build your address based on sheet and table name
This sheet contains the data that I will retrieve
And this sheet will show the result
As soon as I change the table name it will pull the data from the other table
Formula for cell B5: INDIRECT(CONCATENATE(B2,"::",ADDRESS(2,2,1,FALSE,B3)),FALSE)
Based on your region the , or the ; will be used to separate the different sections of a formula.
Hope this will help
Ralf
Numbers Indirect Function another sheet any Table column?
