C
chrisrowe_cr
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 hel
addressing!
=INDEX('Names Range',MATCH(1,('Risk Value Range'=B5)*('Product Ratin
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 produc
may have a 4 risk rating, but under the section for risk rating 3 th
number 1 product may actually only be the number 2 rated product if yo
see what I mean. I basicaly need the formula to pick the hightest rate
product with x risk rating. If it helps the max number of product
would be about 8.
Make sense
However I neglected to spot a glaring error that I need hel
addressing!
=INDEX('Names Range',MATCH(1,('Risk Value Range'=B5)*('Product Ratin
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 produc
may have a 4 risk rating, but under the section for risk rating 3 th
number 1 product may actually only be the number 2 rated product if yo
see what I mean. I basicaly need the formula to pick the hightest rate
product with x risk rating. If it helps the max number of product
would be about 8.
Make sense