Drop down list with multiple columns

[firetyrant]

I have a quandry. I am trying to create a drop down list or similar to show me All employees and the single task they "HAVE NOT" been trained on yet. I have 52 employees and 20 tasks they need to be trained on. I know I can create a table and add a filter to show ALL employees that have not yet been trained on those certain tasks, but I want to only show a single task by itself and what employees they are. In drop down menu choose "James", returned data only shows the tasks they have not been trained on. Example of what I'm working with so far. Using Excel 2016

Name	Fork Lift	Bailing	Inventory	Shipping	Stocking	Receiving
Joe	Trained	Trained	Trained	Not Trained	Trained	Trained
James	Not trained	Not trained	Trained	Trained	Not trained	Not Trained
Cathy	Trained	Not Trained	Trained	Not Trained	Trained	Not Trained
Don	Trained	Trained	Not Trained	Not Trained	Trained	Trained
Jake	Not Trained	Not Trained	Not Trained	Trained	Not Trained	Trained

<tbody>
</tbody>

 

[mumps]

In which cell is the drop down menu containing the names? Where do you want to display the end result?

 

[Fluff]

Hi & welcome to MrExcel.
How about, with the drop-down in J2

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J
1	Name	Fork Lift	Bailing	Inventory	Shipping	Stocking	Receiving
2	Joe	Trained	Trained	Trained	Not Trained	Trained	Trained			James
3	James	Not trained	Not trained	Trained	Trained	Not trained	Not Trained			Fork Lift
4	Cathy	Trained	Not Trained	Trained	Not Trained	Trained	Not Trained			Bailing
5	Don	Trained	Trained	Not Trained	Not Trained	Trained	Trained			Stocking
6	Jake	Not Trained	Not Trained	Not Trained	Trained	Not Trained	Trained			Receiving
Forecast

Cell Formulas
Range	Formula
J3	=IFERROR(INDEX($B$1:$G$1,AGGREGATE(15,6,(COLUMN($B$1:$G$1)-COLUMN($B$1)+1)/(INDEX($B$2:$G$6,MATCH($J$2,$A$2:$A$6,0),0)="Not Trained"),ROWS($A$1:$A1))),"")