vlookup where a cell selects which sheet data is pulled from

[muhleebbin]

Hi,

A traditional vlookup would look like the following:

VLOOKUP(Report!$D23,'Test 1'!$A$3:$AZ$300,Report!F$19,FALSE

Is there a way where the sheet 'Test 1' could be governed by a cell on another sheet "Variable" cell E1? I found code that could vlookup across multiple sheets however one requirement was the same order of columns, because this is for an accounting project, the number of columns will increase as the year passes and I wasn't sure if that would still fit the requirement.

Thanks in advance for your help!

 

[muhleebbin]

Found the answer.....

VLOOKUP($D23,INDIRECT("'"&Variables!$E$1&"'!"&"$A$3:$AZ$300"),Report!F$19,FALSE