Help with categorizing my data

So I have a list of 36 character traits. For each trait there are 7 measurements (representing seven different individuals). I have created categories for each character trait and am trying to figure out how to easily create a table that puts each individual character trait measurement into an appropriate category without switching up the order.
any ideas other than going through by hand?

My data looks something like this:
A B C D E F G H
species: fak spil mic maa cal col afr
Head Length: 52.3 66.543 57.894 78.9 55.678 54.32 71.4
Snout Length: 3.3 4.5 3.67 3.89 4.32 4.33 5
Fin rays: 16 15 16 16 15 17 13


for each character trait I have a different set of categories based on the quintiles from each character trait's value set. I am trying to create a table that has the character traits along the side, the species along the top and instead of individual values, the categories (or quintile) that each value fits into.

thanks!

Thanks for the tip, here is my sample workbook. The first sheet shows my data, the second sheet shows the quintiles that I am
using to define five categories (1, 2, 3, 4, 5) within each set of values and the third sheet shows how I want the results to be displayed.

Sure, here is an example using 10 categories
again the first sheet is the raw data
the second sheet shows how the values are categorized
and the final sheet shows the final product

Well if you had copy and pasted the columns that define the 7th category (columns H and I) you would see that the value 3.91 falls within the
range that defines category 7. You can see this clearly in the picture I just uploaded. Anyway I finally got my Excel Savvy
friend to take a look and figured out that I can use various IF equations to build one large equation relating each set of rules back to a single box and then edit which column letters/row numbers change or don't change. So I have figured it all out. But thank you all for your help!

Screen Shot 2013-11-23 at 6.23.05 PM.png