ashleighfranklin
New Member
- Joined
- Sep 27, 2010
- Messages
- 2
Hi there,
I was hoping someone could help me with this. I have tried researching but am not getting anywhere...
Currently I am trying to do a vlookup, to see if I have booked in people for too many hours for any particular day (they are allowed 6 per day but it is tricky because they can be working across several projects).
So it looks something like this:
Project------Name of person allocated-----Monday-----Tues------Wed
Project X---------Person A-----------------------4-------------3-----------4
Project Y----------Person B-----------------------3-------------4-----------3
Project X----------Person C-----------------------6-------------6-----------2
Project Y----------Person A-----------------------3-------------3-----------2
Project Z----------Person A-----------------------2-------------6-----------2
Project X----------Person C-----------------------4-----------2-------------4
The problem is that Vlookup only returns the first item's corresponding cell. Because I need to know if a person has been overbooked for any particular day, I think I need a vlookup that sums all answers together. (I can then do conditional formatting so that if it exceeds 6 then it will show as red/flagged as an issue.
Any help would be greatly appreciated!!
Thanks in advance
I was hoping someone could help me with this. I have tried researching but am not getting anywhere...
Currently I am trying to do a vlookup, to see if I have booked in people for too many hours for any particular day (they are allowed 6 per day but it is tricky because they can be working across several projects).
So it looks something like this:
Project------Name of person allocated-----Monday-----Tues------Wed
Project X---------Person A-----------------------4-------------3-----------4
Project Y----------Person B-----------------------3-------------4-----------3
Project X----------Person C-----------------------6-------------6-----------2
Project Y----------Person A-----------------------3-------------3-----------2
Project Z----------Person A-----------------------2-------------6-----------2
Project X----------Person C-----------------------4-----------2-------------4
The problem is that Vlookup only returns the first item's corresponding cell. Because I need to know if a person has been overbooked for any particular day, I think I need a vlookup that sums all answers together. (I can then do conditional formatting so that if it exceeds 6 then it will show as red/flagged as an issue.
Any help would be greatly appreciated!!
Thanks in advance
