Try
with sheetname in cell C1

=IF(INDIRECT("'" & C1 & "'!P9")0,Sheet2!A4,"")

--
Jacob


"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!P90,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.