Take a look at the InDirect function.
HTH,
Gary Brown


"datachall" wrote:

I am tring to utilize formulas to access data on my companies server. The
data is Excel worksheets that are placed there by another department and I
want to read a certain field out of these files. I would like to be able to
enter the file name in my worksheet and have the formula perform a data
lookup. Is there any hope of me ever being able to do something like this?