=INDIRECT(formula)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Doug Davey" wrote in message
...
The "Sheet1!A1" is an output from a conditional formula (IF function). I
can't use the reference as the output without including the quotes - and I
have 32 lists of these references that don't reference.

Perhaps I can phrase my question a different way - is there a way to
include
a cell reference on a different worksheet as an output from a conditional
formula?

Thanks for the help...

"Mike H" wrote:

remove the quotes and ensure the cell is formatted as general

"Doug Davey" wrote:

Is there a way to convert the text "=Sheet2!a1" into a format that will
tell
Excel to use it as a reference to the worksheet?

This seems like a simple thing, but I can't figure it out...