VLOOKUP question

Gday all,

I am just wondering if this was possible:

I have a timesheet worksheet - and the employees fill it in against project numbers. The cell to the right of each "item" has the total number of hours spent on that project.

However, during the week, we could jump to and from multiple projects.

My query is, can I do a VLOOKUP from my main workbook to an employee timesheet, search for a particular project number in column C, and then it would pick up the corresponding number (of hours) in column L.

Basically a formula which searches for a value (in column C), and then returns the value in the adjacent row of a different column (column L).

Furthermore, it would be even better if the formula found ALL the same project numbers within the weekly worksheet, and did a sum of all hours in the adjacent cell of column L.

I can post a mock sheet if required.

Thanks again for everyones help - I am very new to Excel!

Kind regards,
Andy