Dynamic range of cells

[DavidVeilleux]

Hi,

I'm trying to have a range of cells vary according to other factors.

INDIRECT(ADDRESS(1;MATCH("Y";AT2:BZ2;0)

What is highlighted in red is what I want to change according to other formulas. The thing is you can't put it in text so I don't know how to have it written in the formula to be identified as a cell.

Thanks!

 

[FDibbins]

You are already using INDIRECT, so why not just include that as a reference from somewhere?

what exactly are you trying to do here, you may be making this more complex than it needs to be?

 

[DavidVeilleux]

You are already using INDIRECT, so why not just include that as a reference from somewhere?

what exactly are you trying to do here, you may be making this more complex than it needs to be?

I don't think I can use Indirect as it returns a value of a specified cell and what I want to do is find a way to return a cell address to use it in a range.

=INDIRECT(ADDRESS(1,MATCH("Y",address(2,1):BZ2,0)))

The part in red, which is the first argument of the range I validate in my match formula, I do not know how to have it change according to a formula or other factors.

My main issue is illustrated in this post :
https://www.mrexcel.com/forum/excel...s-multiple-cells-according-variable-data.html

Thanks for the help