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.