Hi,

Try =INDIRECT("A"&B2) which gives you the value in the cell A5. I think
that's what you mean.

HTH

David

"Farrel" wrote:

I want to chage the row selection on a function by using a cell reference
"A(B2)"
so when I change "B2" to 5
the function will read "A5"
TXS