Let's say cell E2 contains the text Sheet3
then
=INDIRECT(E2 & "!" & "E7") is what you want.


The trick is that between the parenthesis you want a string that represents
an address
--
Gary's Student


"superkopite" wrote:


Hiya guys and gals

I have the following code;

=INDIRECT("E2"!, E7)

From what i understand from the help files this should work, unless i
am being stupid (highly probable)

What I want it to do is for the host cell to display the value of cell
E7 from another worksheet, the name of the work sheet is in cell E2.

Like i said i have searched the help files and this seems to be the
method that is best.

Regards
James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=515417