Set a range in a formula based off the value of a cell

[criscocube]

Hi all,

Simple question, but I am confused... tried using versions of indirect and concetenate with no luck.

How do I set the below formula range to be based off the value of a cell?

=INDEX([I][B][U]valueofcell[/U][/B][/I]:$M$2,MATCH(TRUE,[I][B][U]valueofcell[/U][/B][/I]:M3>0,0))

The cell I am getting the value for e.g. has the value of "J3" (it comes from the formula:

=ADDRESS(A3,C3+6,4)

)

Thanks!

 

[Marcelo Branco]

far more clever, works perfect! thank you very much!

You are welcome. Glad to help

M.