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

With worksheet name in D1

=VLOOKUP(A1,INDIRECT("'"&D1&"'!A1:B50"),2,0)

adapt to fit accordingly


--

Regards,

Peo Sjoblom

"jackebro" <jackebro.20191n_1134568501.2248@excelforum-nospam.com> wrote in
message news:jackebro.20191n_1134568501.2248@excelforum-nospam.com...
>
> 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
>

thanks Peo Sjoblom works perfectly