Thanks to all that helped me arrive at this point in the 1st place! However I neglected to spot a glaring error that I need help addressing!

=INDEX('Names Range',MATCH(1,('Risk Value Range'=B5)*('Product Rating Range'=1),0))

Thats my formula, and as it stands it works for how it has been setup, however as there are different sections for risk, the number 1 product may have a 4 risk rating, but under the section for risk rating 3 the number 1 product may actually only be the number 2 rated product if you see what I mean. I basicaly need the formula to pick the hightest rated product with x risk rating. If it helps the max number of products would be about 8.

Make sense?