I have about 200 files that have a spreadsheet of active jobs (each job
is saved as it's own name). The spreadsheets list the project manager
and the total # of hours he expects to work on that job. I need to
gather that information into one master sheet. On the source
spreadsheets the project managers are listed in column B and their
respective hours are in column D. On the master spreadsheet I have all
the managers listed in row 1 from left to right (approx 30). In column
A I have all the jobs listed going down. I need to put a formula in
each cell so it will show the corresponding hours for that project
manager and job.

I tried using Vlookup but I get a N/A.

Any help or suggestions would be greatly appreciated.


I'm using Excel 2003 on Windows XP.

If you need clarification please email me and I can
send you a copy of the files to look at.

Thanks.


--
Tom K
------------------------------------------------------------------------
Tom K's Profile: http://www.excelforum.com/member.php...o&userid=12124
View this thread: http://www.excelforum.com/showthread...hreadid=530578