Creating cell references with variable values to use in Vlookup

J

jackebro

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
 
P

Peo Sjoblom

With worksheet name in D1

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

adapt to fit accordingly
 
Top