Yes, try:-

=IF(A1=1,Sheet2!A1,Sheet3!A1)

Mike

"Doug Davey" wrote:

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...