Cell reference question
 

I would like to enter a value in a cell which represents
a row in another sheet and have a formula(s) reference
that cell. ie the current formula is =Import!P9-B6; what
I want to accomplish is to enter the 9 in a cell (A10)
and have the series of formulas look to that reference
such as =Import!P&A10-B6 where A10 contains a 9.

Any help would be appreciated.

Tim

Cell reference question
 

Hi
use
=INDIRECT("'Import'!P"&A10)-B6

--
Regards
Frank Kabel
Frankfurt, Germany


Tim wrote:
I would like to enter a value in a cell which represents
a row in another sheet and have a formula(s) reference
that cell. ie the current formula is =Import!P9-B6; what
I want to accomplish is to enter the 9 in a cell (A10)
and have the series of formulas look to that reference
such as =Import!P&A10-B6 where A10 contains a 9.

Any help would be appreciated.

Tim