Creating cell references with variable values to use in Vlookup
 

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

Creating cell references with variable values to use in Vlookup
 

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

Creating cell references with variable values to use in Vlookup
 

thanks Peo Sjoblom works perfectly


--
jackebro
------------------------------------------------------------------------
jackebro's Profile: http://www.excelforum.com/member.php...o&userid=29628
View this thread: http://www.excelforum.com/showthread...hreadid=493383