VLOOKUP question

**Mehhico** · 02-22-2010, 02:56 AM

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

**zbor** · 02-22-2010, 03:02 AM

Yes, an example workbook would be fine

**JBeaucaire** · 02-22-2010, 03:05 AM

A mockup would be helpful, but in the meantime look up the SUMIF() formula, it sounds like what you need.

**Mehhico** · 02-22-2010, 03:17 AM

Thank you for the comments.

I have attached a brief sample of what I am after - any comments will be appreciated.

There is sooo much to MS Excel - and I thought AutoCAD was a big program.....

I will check out SUMIF() in the meantime.

Thanks again,
Andy