vlookup formula

[West]

Is it possible to use a cell refence, in which the referred to cell
lists the workbook and array, as the range for a lookup formula.

I am attempting to use the same VLOOKUP formula to access a variety of
files which are employee timesheets. I am using a CONCATENATE to build
the correct file name for a given timeperiod and employee placed in
CELL A1 - now I would like to insert this filename in the Range
portion of the lookup file by telling the formula to look in cell A1
for the filename, but cannot seem to find a way to do this, the formula
wants to find a file with the name A1.

any ideas?

thanks, West.

 

[Niek Otten]

Hi West,

Difficult to judge from here, but take a look at the INDIRECT() function.
Look in HELP for details

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel