Vlookup w/ multiple files

Hello All,

I have 22 separate files that I am attempting to pull information from using vlookup (back to a master file). All files are stored on a shared drive and each file is accessed by a different user. I am attempting to direct vlookup to a specific file (i.e. doe.xls) based upon the user name in the master file. If user = John Doe lookup data in doe.xls. Therefore, instead of sifting through 22 files it would go directly to the source file.

I am familiar with vlookup, but I am not sure if this particular command is possible.

Any assistance would be greatly appreciated.

Thanks in advance!

Justin

Excellent! Thank you for the prompt response!

Justin

Hello,

I want to download this addin Morefunc.xll, but it's not possible anymore.
Does anyone know where I can download this?

Thanks,
Rgds,
Mathieu