using value of another cell as row reference number

charles · Sep 24, 2003

Hi! How can I use the value from another cell as current row refernce
number, e,g., A(B2)? Thanks in advance.

dvt · Sep 24, 2003

charles said:
Hi! How can I use the value from another cell as current row refernce
number, e,g., A(B2)? Thanks in advance.

=INDIRECT("A"&B2)

Dave
dvt at psu dot edu

charles · Sep 24, 2003

Dave, Thanks a lot. It works great!

dvt said:
=INDIRECT("A"&B2)

Dave
dvt at psu dot edu