Max Date If statement multiple conditions

Hi, I am trying to do what I believe should be relatively simple. I have a calendar, under each date I have several exercises. I also have a list of exercises as a reference. I am trying to find the max (latest) date for when each exercise occurred and display it next to the reference list of exercises. Photo and workbook attached. I have been using curly brackets for multiple arrays This is what I have so far

Formula:

Please Login or Register  to view this content.

Excel will return the max date for the entire calendar if it contains the specified input. I am trying to get it to return the max date if it has the input under that date. When I LOOKUP has not allowed me to select multiple criteria, As you can see, excel keeps returning 8/7/2015 but the input Back Extension isn't under that date. It should return 8/6/2015 for back extension and 8/7/2015 for back squat. I am at a loss.

Excel Issues.JPG

HI, welcome to the forum

If that is what your tables look like, I would suggest a restructure to make life easier for yourself. Excel works best with 2-dimensional tables, not with blocks of data like you have there.

Consider putting your dates doen column A, with the different exercises across the top, and the data in the body of the table