VLookup with multiple return cells - Can I sum these up?

Project + Timesheet - Sample.xlsxAttachment 252659Hi!

I think there might be an easy way to do this, but it's been a while since I took an Excel course and I'm stumped.

I have two tabs on a spreadsheet, one has a list of project numbers, and I need to add a row for how many hours were worked on each project. The timesheet is the next tab, and there are multiple entries for each job number. I've attached a sample spreadsheet, and here's a list of what I'd like to do:

1) Vlookup in A2 on "NonProjects" tab for the "Job Number" on the "Timesheet" tab.
2) The job numbers found on "Timesheet" will each have multiple entries; the total amount of time is in column F and is formatted to show 1.40 (one hour, 40 minutes).
3) I want to sum up all of the time for each job number and return that total to column B on "NonProjects" tab.

Any suggestions??

Thanks very much!Attachment 252657

With an pivot table.

See the attached file.

I don't get the point.

Put the desired result in your sheet and post it again.