Originally Posted by DieselDork

Greetings!

I've finally run up against a wall, and need to plead for help.

What I have is this:

A list of 50 employees, and their available time (# of hours consolidated monthly) for 12 months.

a b c d e f g h i j k l m
Bob Network 64 120 177 0 0 0 0 0 0 0 0 0


I have another worksheet that contains 50 projects and the required time for each project (# of hours consilidated monthly) for 12 months.

a b c d e f g h i j k l m
projectName 20 16 25 0 0 0 0 44 55 78 99

Each project will require 4 employees each with a different skillset (Lead, Platform, Network, Storage).

What I need to do is find a Lead, Platform, Network and Storage employee for each project.

I need to end up with a worksheet containing project names and each of the 4 employee names that are available to work on that project.
a b c d e
ProjectName Bob Cindy Carla Steve

I've tried all manner of things to accomplish this, and have finally given up.

I've attached a spreadsheet with sample data to better illustrate what I'm trying to accomplish.

Can anyone help with a series of formulas/functions?

THANK YOU!!!!

Originally Posted by Spencer101

Hi,

Do each of the engineers on the "Availability" tab have all four skill sets, or are they restricted to only one or some?