Barnes2912
New Member
- Joined
- Jan 21, 2018
- Messages
- 2
Hello all,
I would really appreciate your help on this!
I have a table [Project Plan Table] with a list of different projects that I manage (column A), names of people in my team (column B) [Resource] and the number of billable hours that they are should book against each project (column C), along with a second worksheet with another table of allocate hours for each staff member [Allocated Hours].
{=((VLOOKUP([Resource],[Allocated Hours],2,FALSE)))-(SUBTOTAL(109,[Jan]))}
Where [Resource] is the column name of the member of staff in the [Project Plan Table].
The way the subtotal function will sum only the number of hours that are visible on a filtered table, I want to be able to do the same for a vlookup. If I filter by a member of staff's name in my table, I want my vlookup to pick up that filtered name (in column B - [Resource]) to be able to find the matching name in the other table [Allocated Days].
When I use the slicer tool, the formula works but only for the first name in the table, rather than the filtered name.
Please can you help with this query please? I hope this makes sense!
I would really appreciate your help on this!
I have a table [Project Plan Table] with a list of different projects that I manage (column A), names of people in my team (column B) [Resource] and the number of billable hours that they are should book against each project (column C), along with a second worksheet with another table of allocate hours for each staff member [Allocated Hours].
{=((VLOOKUP([Resource],[Allocated Hours],2,FALSE)))-(SUBTOTAL(109,[Jan]))}
Where [Resource] is the column name of the member of staff in the [Project Plan Table].
The way the subtotal function will sum only the number of hours that are visible on a filtered table, I want to be able to do the same for a vlookup. If I filter by a member of staff's name in my table, I want my vlookup to pick up that filtered name (in column B - [Resource]) to be able to find the matching name in the other table [Allocated Days].
When I use the slicer tool, the formula works but only for the first name in the table, rather than the filtered name.
Please can you help with this query please? I hope this makes sense!
