find most recent and table lookup

[lahellm]

I am designing a worksheet for someone who is less experienced in excel. Our goal is to be able to paste data into a table and have another table show that which people are delinquent in getting training done that has to be done on regular intervals. The other goal is to get another table to record just the completion dates of when the last training was completed without manually entering them each time.

I've tried the 2 dimensional lookup to just get the dates over but it doesn't seem to work. I know this may be an easy one but I can't seem to figure it out.

I've drafted an example data sheet with one tab of data and another tab with a table that would have the delinquent notifications shown.

Any ideas on how to complete this would be greatly appreciated.

Here is what the data sheet has:

Clock	Name	Code	Description	start date	end date
101039	Deb Smith	SFTY128	Pipeline training	1/5/2015	3/5/2015
101039	Deb Smith	SFTY123	Safety ATV	1/1/2015	3/1/2014
101039	Deb Smith	SFTY125	OSHA 10 hour	2/1/2013	6/2/2013
101039	Deb Smith	SFTY125	OSHA 10 hour	1/1/2012	2/1/2012
101040	John Smith	SFTY124	First Aid	1/6/2015	4/6/2015

<tbody>
</tbody>

On the second tab for notifications, I formatted it like:

Clock	Name	Training1	Training2	Training3	Training4	Training5	Training6
		Safety ATV	First Aid	OSHA 10 hr	confined spaces	lock out	Pipeline training
		SFTY123	SFTY124	SFTY125	SFTY126	SFTY127	SFTY128
		1 year	2 years	1 year	1 year	1 year	6 months
101039	Deb Smith	3/1/2014		6/2/2013			3/5/2015
101040	John Smith		4/6/2015
101041	Sue Smith
101042	Josh Smith

<tbody>
</tbody>

 

[lahellm]

Figured it out. Pivot tables are a wonderful thing!