=INDIRECT(A1amp;quot;!quot;amp;quot;B1quot;)--
Regards,
Davequot;eklarsenquot; wrote:
gt;
gt; Column quot;aquot; has the name of the worksheet that I want reference.
gt; I always want it to return the value on worksheet quot;Namequot; column B.
gt;
gt; Is there a formula other then doing it manually =quot;Sheetnamequot;!B1
gt;
gt;
gt; --
gt; eklarsen
gt; ------------------------------------------------------------------------
gt; eklarsen's Profile: www.excelforum.com/member.php...foamp;userid=9001
gt; View this thread: www.excelforum.com/showthread...hreadid=493955
gt;
gt;
Column quot;aquot; has the name of the worksheet that I want reference.
I always want it to return the value on worksheet quot;Namequot; column B.
Is there a formula other then doing it manually =quot;Sheetnamequot;!B1--
eklarsen
------------------------------------------------------------------------
eklarsen's Profile: www.excelforum.com/member.php...foamp;userid=9001
View this thread: www.excelforum.com/showthread...hreadid=493955
Worked great, thanks--
eklarsen
------------------------------------------------------------------------
eklarsen's Profile: www.excelforum.com/member.php...foamp;userid=9001
View this thread: www.excelforum.com/showthread...hreadid=493955
留言列表
