LinkBack URL
About LinkBacks
Hi Guys, I am probably going about this the wrong way but I am trying to do the following:
1) I have a column next to my employees list that identifies the department they work in, e.g. MFRF or MFRR or MFRP.
These are the codes I am forced to use as this is how the information is given to me via the accounts department.
I need to sort them by department and breakdown the labour costs per department.
To that end I have created 3 columns that sit at the side of the employee list.
Each column has a header, e.g MFRF or MFRR etc
I have used Vlookup, which essentially looks at the code of it's respective column then looks at the code for the employee on that row and if it is the same it returns the amount of hours that employee has worked in the column that matches that employees code.
The problem I am having is that if the employee code doesn't match the code at the head of the column it returns "N/A"
I would like it to return "0"
Is there a way of doing this, or an alternative approach to the problem?
Hope this makes sense.
I've attached the spread sheet so far to help you make sense of the problem.
The concept is that when I get the hours which will be formatted exactly as they are in the red box but on a seperate sheet. I can copy the hours as they are and paste them into the red box on my sheet.
This should then automaticallt break the hours down by department and then the front sheet I haven't made yet will detail the hours by department on a week to week basis throughout the year.
The sheet you can will be replicated 52 times and updated weekly pasting the figure into the appropriate sheet.
Regards
Marv
Register To Reply
Bookmarks