Searching for exact phrases

I currently have a listing of all plays run by a high school football team for the 2010 season. What I'd like to do is take that data and break it down into some meaningful statistics. What I'm trying to do is break down all offensive plays into 5 distinct areas:

run inside
run outside
pass short
pass medium
pass long

I have it currently set up so that I can break the plays down into run inside, run outside, and pass. Now I'm trying to break down the passes into short, medium, and long. I want anything 1-10 yards to be considered short 11-20 medium and 20+ yards as long. So, with my limited excel knowledge I thought about using the formula =ISNUMBER(SEARCH("1 yard", F2)) and then just changing the yard parameter. (2 yard, 3 yard, 4 yard, etc) The issue with this though is if I have "A Smith passes to J Jones for a 16 yard gain" the formula will return a positive result for both 6 yards and 16 yards. Is there a better way to do this, or is there a way to get the search function to return to me just a TRUE value for 16 and not the 6 and 16 column?

I've attached a sample of the workbook data as suggested.