Using a Cell Value to Reference a Sheet in a Formula

[sbrnard]

I'm trying to use HLOOKUP on a spreadsheet with multiple tabs that are named as weeks of the year. Is it possible to reference a cell value in the HLOOKUP formula that represents the tab name? In this example (=VLOOKUP(A5,Sheet2!A1:K24,3,0)), instead of listing "Sheet2!" in the formula, reference a cell in place of Sheet2! where I can enter different tab names.

[63falcondude]

Take a look at the INDIRECT function.

[63falcondude]

More specifically, with the sheet name (Sheet2 in your example) in cell Z1, try this:

=VLOOKUP(A5,INDIRECT("'"&Z1&"'!A1:K24"),3,0)