Maybe I've got too much going on in this thing, I'm not sure. I've spent the last week trying to get to know the functions I've used in my tracker, indirect is new to me but it isn't what is giving me problems. Only today I've discovered vlookup has been reporting the wrong scores here. When I went back and looked at the original calculator I've based all of my work on did I realize that it was also giving erroneuos scores. Then after numerous google searches did I find how limited the TRUE in vlookup is, and multiple recommendations to switch to an index/match formula instead. And that is where I am completely lost. I made a couple attempts and failed. I really wish there was a way to make true always round up but I couldn't find anything. Attached is a sample workbook. Just look at the run scores. those are the only things relevant with this issue.

The run scores are simple. a point is added at every 6 second interval. based on the age/*** and run time a score is determined. 19 year old male runs a 1554(this is how 15 minutes 54 seconds is represented in the tables) he gets 60 points. anywhere from 1555 to 1600 is 59 points, which makes the run a fail(any score in any category below 60 produces "fail." but as I've shown on the worksheet, these scores between 1554 and 1559 are producing a 60 and as a result a "pass." which is unacceptable.

I need fresher eyes and smarter minds.

vlookuptrueproblem.xlsx