Hi
Allthough the vlookup-idea is the best idea, it's posible to use more than 7 if's in one cell.
If you chain them instead of embedding them you would get the result you're looking for.
Try this and see if it works for you. (it does for me)
=IF(OR(V1=V40,V1<=V41),"Philly Pride II","")&IF(AND(V1>V41,V1<=V42),"Egoholics","")&IF(AND(V1>V42,V1<=V43),"Hail Marys","")&IF(AND(V1>V43,V1<=V44),"Rice A Roni","")&IF(AND(V1>V44,V1<=V45),"Dallas Devestators","")&IF(AND(V1>V45,V1<=V46),"Packers2003","")&IF(AND(V1>V46,V1<=V47),"Clutch Ballers","")&IF(AND(V1>V47,V1<=V48),"Hamilton Hurricanes","")&IF(AND(V1>V48,V1<=V49),"Womping Wombats","")&IF(AND(V1>V49,V1<=V50),"Under Dogs","")
regard Tommy