Prev: SOLVED: Input calculation in specified rows and columns
Next: running time
From: navel151 on 20 Feb 2010 02:47
TY all - INDIRECT is the function I needed but am having some errors on some
cells so may be looking for more input later.

"navel151" wrote:

> I would like to set up a formula that uses the text from an adjacent cell to
> determine the sheet and cell location that is used in the formula. i.e.
> instead of =IF(sheet1!P9>0,sheet2!A4,"") I would like the sheet1 part of the
> formula to be the text from a cell beside the formula cell. How do I do tell
> the formula to use that text rather than havin gto specify the sheet each
> time?
>
> Thx.
First  |  Prev  | 
Pages: 1 2
Prev: SOLVED: Input calculation in specified rows and columns
Next: running time