Problem with Indirect Function

[Totoro318]

Hey guys. So I've got my indirect function as such: =INDIRECT("P"&(2+3)). Naturally, this will return the value in cell P5. Which it does.

My problem is that I want it to return the value in P5 on sheet 2. However, when I revise my function to look like this: =Sheet2!INDIRECT("P"&(2+3)), it returns an error function. So does this: =INDIRECT((Sheet2!)"P"&(2+3)).

Does anybody have any ideas on how to correct this error?

[djapigo]

Try this... =INDIRECT("Sheet2!P"&(2+3)).

[Moo the Dog]

Try this:

=INDIRECT("Sheet2!P"&(2+3))

- Moo

djapigo snuck it in nanoseconds before me...

[FDibbins]

totoro, whenever I have a problem sorting out an indirect() formula, i 1st create the formula in the normal way. Then i "text" it by adding ' in front of the =, so I can see what it is supposed to look like.

Then I play around with indirect() in the formula editor until it shows me what i need

[Totoro318]

Thank you guys, you were all incredibly helpful.

[Moo the Dog]

Glad to help, and thanks for the feedback.

- Moo