With worksheet name in D1
=VLOOKUP(A1,INDIRECT("'"&D1&"'!A1:B50"),2,0)
adapt to fit accordingly
--
Regards,
Peo Sjoblom
"jackebro" wrote in
message ...
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:
http://www.excelforum.com/member.php...o&userid=29628
View this thread: http://www.excelforum.com/showthread...hreadid=493383