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?


--
chrisrowe_cr
------------------------------------------------------------------------
chrisrowe_cr's Profile: http://www.excelforum.com/member.php...o&userid=25220
View this thread: http://www.excelforum.com/showthread...hreadid=388680