Data in cell to reference a worksheet page

Column "a" has the name of the worksheet that I want reference.
I always want it to return the value on worksheet "Name" column B.

Is there a formula other then doing it manually ="Sheetname"!B1

=INDIRECT(A1&"!"&"B1")


--
Regards,
Dave


"eklarsen" wrote:

>
> Column "a" has the name of the worksheet that I want reference.
> I always want it to return the value on worksheet "Name" column B.
>
> Is there a formula other then doing it manually ="Sheetname"!B1
>
>
> --
> eklarsen
> ------------------------------------------------------------------------
> eklarsen's Profile: http://www.excelforum.com/member.php...fo&userid=9001
> View this thread: http://www.excelforum.com/showthread...hreadid=493955
>
>

Worked great, thanks