Just a clarification:
The suggested set-up contains an implicit tie-breaker for col C ("Rating")
in Sheet1. Should be any ties in the "Ratings" col for any given value in
the "Risk Val", the set-up in Sheet2 will still extract *all* the desired
results, with any tied rating lines appearing in the same relative order as
they are in Sheet1.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----