vlookup or if statement help (?)

[ljbrown]

Moderators: Please forgive me if I posted this query in the wrong place. I am unsure if it belongs under the Excel Forum as it deals with formatting cells or the Excel Formulas & Functions as it is needed for a countifs statement. Please forgive me in advance if I have posted this in the wrong location and please relocate it to the correct place. In addition, I apologize if this has been posted before. I have searched the forum and google for many hours before resorting to post on this forum. If it has been posted before, please point me in the right direction.

I have a list of staff members and I need to a formula to help list which staff are due for renewal. I have the data organized in a spread sheet with employee name and when they completed training. I would like to be able to enter a date under and generate a list to say who's training has expired before this date. Is it possible to include blank cells for those new hire staffs that have not yet been to training or is unknown?

I am attaching an abridged spreadsheet. i placed the data on the tab marked staff. I then have tabs for each discipline that we would like to list each employee that needs to attend class.

Currently we sort, resort, and resort again to find the information but it can be cumbersome. i think the answer lies within a vlookup or if statement. I was able to do something with an if statement, but i have to copy and paste staff names to the left. My issues with that is that staff fluctuates (retire, resign, new hire...) Id there a way to pull the name from the other tab as well to maintain integrity?

I have tried and tried but am having an issue getting my head wrapped around this.

Any and all help is appreciated.

Lance