"NeedAdvice777" <NeedAdvice777@discussions.microsoft.com> wrote in message
news:10AD22A0-1DB6-4D8D-B162-C3B96BDFC44F@microsoft.com...
> It works if I use only Sheet2!F4, but not if I use the cell range. Same
> problem I've been having.

Post the *EXACT* formula you tried.

You say: "It works if I use only Sheet2!F4, but not if I use the cell
range."

What does it do when it doesn't work? Get an error? Incorrect result?

Biff