Ford,
I think I've should have clarified - the master file contains all the IDs and I was using vlookup to pull the data from the Master file which is very large in size (108MB). Now I've split each ID's information into a separate files. So did you mean to use Vlookup on the separate files? If yes- how do I reference the right file (ID_#)?

Thanks.