Assigning staff based on hours required and staff hours available

[xcelente]

Hello all!

I have an Excel problem where I need to assign employees to a task based on 1) hours required for that task and 2) employee hours available. Here is the data I have:

Employee	Week Apr 22 hours available	Week Apr 29 hours available
Employee A	15	20
Employee B	0	10
Employee C	10	0

<tbody>
</tbody>

Project	Week Apr 22 hours needed	Week Apr 29 hours needed
X	0	5
Y	10	10
Z	15	10

<tbody>
</tbody>

I want to get all possible staffing options (e.g., multiple employee names to choose from) for each week for each project.

Can anyone help? Thank you so much!