software

I would like to create cell references within a Vlookup statements using
variable data within a cell to access a coresponding worksheet within
the same work book eg worksheets would be Monday Tuesday Wednesday and
the worksheet that would be calling the data would have a column with
the same values--
jackebro
------------------------------------------------------------------------
jackebro's Profile: www.excelforum.com/member.php...oamp;userid=29628
View this thread: www.excelforum.com/showthread...hreadid=493383With worksheet name in D1

=VLOOKUP(A1,INDIRECT(quot;'quot;amp;D1amp;quot;'!A1:B50quot;),2,0)

adapt to fit accordingly--

Regards,

Peo Sjoblom

quot;jackebroquot; gt; wrote in
message ...
gt;
gt; I would like to create cell references within a Vlookup statements using
gt; variable data within a cell to access a coresponding worksheet within
gt; the same work book eg worksheets would be Monday Tuesday Wednesday and
gt; the worksheet that would be calling the data would have a column with
gt; the same values
gt;
gt;
gt; --
gt; jackebro
gt; ------------------------------------------------------------------------
gt; jackebro's Profile:
www.excelforum.com/member.php...oamp;userid=29628
gt; View this thread: www.excelforum.com/showthread...hreadid=493383
gt;

thanks Peo Sjoblom works perfectly--
jackebro
------------------------------------------------------------------------
jackebro's Profile: www.excelforum.com/member.php...oamp;userid=29628
View this thread: www.excelforum.com/showthread...hreadid=493383