Hi there I'm needing support with my excel file see below.
I want to look up Supply & demand tab for each col search if value 0 whats the role and project
then lookup Supply tab using input role and project output name or names of resources....
can this be done? Your support is greatly appreciated - thank you inadvance Noreen
-- removed inline image ---
Supply & demand tab:
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
I want to look up Supply & demand tab for each col search if value 0 whats the role and project
then lookup Supply tab using input role and project output name or names of resources....
can this be done? Your support is greatly appreciated - thank you inadvance Noreen
-- removed inline image ---
Supply & demand tab:
| May | |||
| 18 | 19 | ||
| Projects | Project Role | 18 | 19 |
| project 1 | Architect | 0 | 0 |
| project 1 | Business Analyst | -0.1 | -0.1 |
| project 1 | PM | 0 | 0 |
| project 1 | Scrum Master | 0 | 0 |
| project 1 | SW Engineer | 0 | 0 |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
| tab Supply:
<colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
