The function you need to look up in Excel help is INDIRECT.
--
David Biddulph


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.