View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Davey[_2_] Doug Davey[_2_] is offline
external usenet poster
 
Posts: 6
Default Reference another worksheet as an output for IF formula?

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