Lookup/Reference

[Ruthless18x]

Hi,

I am having issues creating a workbook that will be used for time/code tracking.

I created one sheet that has all the codes that I will be using and then created another sheet which is were the time data will be imput. I would like to type the code in on Sheet 1 and have the description pulled from the cost codes sheet. Lastly I would like to have the last page Total the total amount of time charged to each code at the end of the week.

I have included a copy. Any help would be greatly appreciated.

Thanks.

[Dunc3142]

I think I have got what you wanted.
The Code and Disc. were named data
The codes were named data2
The dropdown box is data validation a list and =data for source.
The vlookup uses tthe table above (data) to look up the values
The sumif function totals on the totals sheet based on the code.

[Ruthless18x]

Thanks so much! That is exactly what I wanted.

[Dunc3142]

It is nice to know when you have helped

[Ruthless18x]

I have another question...

Would it be possible to put an employee lookup in front of the code lookup?

Also, would it be possible for everything to be put into a pivot table, so that if the same employee is charged to muliple codes, they will all consolidate under one, if that makes sense?