use address function to indicate range in calculation

[Mayo]

I want to use the address function to indicate the range in the
calculation of a slope:

cell A2 contains the value 20

=ADDRESS(A2,2) returns $B$20
=ADDRESS(A2,3) returns $C$20

Cell B20 and C20 are the starting cells for calculating the slope:
=slope(B20:B25,C20:C25)

But putting the address function in the slope calculation, like
=slope(ADDRESS(A2,2):B25,ADDRESS(A2,3):C25) does not work!

Why can't I combine these functions?
Is there another (simple) way?


Mayo

 

[Tom Ogilvy]

=slope(Indirect("B"&A2&":B25"),Indirect("C"&A2&":C25"))

 

[Mayo]

Thanx to my boyfriend I found the solution myself

The indirect function should be used, it converts text to a cell or
range reference

My example would become:
=slope(indirect("B" & A2 & ":B25"),indirect("C" & A2 & ":C25"))

 

[just_jon]

Try

=SLOPE(INDIRECT("B"&A2&":B25"),INDIRECT("C"&A2&":C25"))

 

[vimal256]

Slope (indirect ("b"&a2&":b25"),indirect("c"&a2&":c 25"))

SLOPE (INDIRECT ("B"&A2&":B25"),INDIRECT("C"&A2&":C 25"))

Can I use above in following way, if B5= B and C5=C

SLOPE (INDIRECT ("(“&B5&")”&A2&":B25"), INDIRECT ("(“&C5&")”&"&A2&": C 25"))
In my case, column is required to referred to any cell to get desired output
Please help.