HI Guys,

I'm using vlookup to reference information from another workbook, but is it possible to adjust this code so the sheet is selected by Cell Reference.

Current Code

=VLOOKUP($B$5,'C:\Users\Admin\Documents\Work Docs\Reports\[Stats.xlsx]MTD'!$A$10:$AB$500,20,FALSE)

but would like the MTD to be changeable by cell value. for example:

C3 value could be one of - MTD, 0106, 0206, 0306

=VLOOKUP($B$5,'C:\Users\Admin\Documents\Work Docs\Reports\[Stats.xlsx]C3'!$A$10:$AB$500,20,FALSE)

Cheers for your help.