Creating cell references with variable values to use in Vlookup

  • Thread starter Thread starter jackebro
  • Start date Start date
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
 
With worksheet name in D1

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

adapt to fit accordingly
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I use OFFSET and VLOOKUP together 1
Vlookup Reference Certain Worksheets 4
Summing VLookup from a variable number of sheets 4
EXCEL - IF(IFERROR(VLOOKUP question 0
Excel Excel Vlookup formula based on cell data 7
VLOOKUP variable array references 1
using VLookup with two variables to get results 2
vlookup with dropdown list 2

Back
Top