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:

[TABLE="width: 479"]
<tbody>[TR]
[TD]Clock[/TD]
[TD]Name[/TD]
[TD]Code[/TD]
[TD]Description[/TD]
[TD]start date[/TD]
[TD]end date[/TD]
[/TR]
[TR]
[TD="align: right"]101039[/TD]
[TD]Deb Smith[/TD]
[TD]SFTY128[/TD]
[TD]Pipeline training[/TD]
[TD="align: right"]1/5/2015[/TD]
[TD="align: right"]3/5/2015[/TD]
[/TR]
[TR]
[TD="align: right"]101039[/TD]
[TD]Deb Smith[/TD]
[TD]SFTY123[/TD]
[TD]Safety ATV[/TD]
[TD="align: right"]1/1/2015[/TD]
[TD="align: right"]3/1/2014[/TD]
[/TR]
[TR]
[TD="align: right"]101039[/TD]
[TD]Deb Smith[/TD]
[TD]SFTY125[/TD]
[TD]OSHA 10 hour[/TD]
[TD="align: right"]2/1/2013[/TD]
[TD="align: right"]6/2/2013[/TD]
[/TR]
[TR]
[TD="align: right"]101039[/TD]
[TD]Deb Smith[/TD]
[TD]SFTY125[/TD]
[TD]OSHA 10 hour[/TD]
[TD="align: right"]1/1/2012[/TD]
[TD="align: right"]2/1/2012[/TD]
[/TR]
[TR]
[TD="align: right"]101040[/TD]
[TD]John Smith[/TD]
[TD]SFTY124[/TD]
[TD]First Aid[/TD]
[TD="align: right"]1/6/2015[/TD]
[TD="align: right"]4/6/2015[/TD]
[/TR]
</tbody>[/TABLE]


On the second tab for notifications, I formatted it like:
[TABLE="width: 678"]
<tbody>[TR]
[TD]Clock[/TD]
[TD]Name[/TD]
[TD]Training1[/TD]
[TD]Training2[/TD]
[TD]Training3[/TD]
[TD]Training4[/TD]
[TD]Training5[/TD]
[TD]Training6[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Safety ATV[/TD]
[TD]First Aid[/TD]
[TD]OSHA 10 hr[/TD]
[TD]confined spaces[/TD]
[TD]lock out[/TD]
[TD]Pipeline training[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]SFTY123[/TD]
[TD]SFTY124[/TD]
[TD]SFTY125[/TD]
[TD]SFTY126[/TD]
[TD]SFTY127[/TD]
[TD]SFTY128[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1 year[/TD]
[TD]2 years[/TD]
[TD]1 year[/TD]
[TD]1 year[/TD]
[TD]1 year[/TD]
[TD]6 months[/TD]
[/TR]
[TR]
[TD="align: right"]101039[/TD]
[TD]Deb Smith[/TD]
[TD="align: right"]3/1/2014[/TD]
[TD][/TD]
[TD]6/2/2013[/TD]
[TD][/TD]
[TD][/TD]
[TD]3/5/2015[/TD]
[/TR]
[TR]
[TD="align: right"]101040[/TD]
[TD]John Smith[/TD]
[TD][/TD]
[TD]4/6/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]101041[/TD]
[TD]Sue Smith[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]101042[/TD]
[TD]Josh Smith[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[lahellm]

Figured it out. Pivot tables are a wonderful thing!