excel VLOOKUP, how to specify dynamic worksheet name?

excel VLOOKUP, how to specify dynamic worksheet name? I'm trying to create a VLOOKUP formula in excel, however, the table array may be in a number of different worksheets.
Asked by: Guest \| Views: 231

Total answers/comments: 1

Comments display order:

Guest [Entry]

"Try using INDIRECT, as in

=Vlookup(a1, INDIRECT(CONCATENATE(""‘[Datafile.xlsx]"",B1,""'!$A1:F500"")),3,False)

where B1 contains the sheet name."