vlookup combined with INDIRECT

[West]

I am using a vlookup to retrieve info from other files (number of hour
spent on a specific job number). I am using INDIRECT to specify th
RANGE for the VLOOKUP as I want to access many files (employe
timesheets).

I am using a CONCATENATE to build file names for all the timesheets fo
each employee for each time period - this is the cell that the INDIREC
function points to for the range of the VLOOKUP.

This is close to working for me except that INDIRECT requires al
external files to be open othewrwise it returns a #REF!

does anyone have any ideas on this

 

[Frank Kabel]

Hi
you may have a look at the following thread:
http://tinyurl.com/2c62u

as you need a range INDIRECT.EXT won't work. Have a look at Harlan
Grove's PULL function