View Single Post
  #2   Report Post  
KL
 
Posts: n/a
Default

Hi Farrel,

try this:

=INDIRECT("A"&B2)

Regards,
KL

"Farrel" wrote in message
...
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