Hi David, Thx for your patience . . . .

I did not state my question clearly. In the following formula,

=INDIRECT("Sheet"&$A$61&"!$C$2")

I want to replace the $A$61 with value in the A column for that row.

Is there a function that will return the value of a specific cell on the
current row?

Example:
Cell A61 contains the value 53.

I want the INDIRECT function to lookup the "Sheet53" without having to put
$A$61 in the formula.

Thx!
Kevin

"David McRitchie" wrote:

Hi Kevin,

=ROW() will provide the cell's row number
=COLUMN() will provide the cell's column number

"KevinB" wrote ...
Cool, that worked! Thx!

Now, my next issue. The formula you provided;

=INDIRECT("Sheet"&$A$61&"!$C$2")