Extending the earlier suggestion a little further ..:

Presuming MyTable is a defined range
referring to a 10 R x 4 C grid
which contains the definitions/rules (say):

0 low R high HR low %
1 low R high HR low %
2 low R high HR low %
3 low R high HR low %
4 low R high HR low %
5 high R low HR high %
6 high R low HR high %
7 high R low HR high %
8 high R low HR high %
9 high R low HR high %

Then, if you have the source numbers for R, HR and %
in cols A to C, row2 down, viz.:

R HR % D
5 8 8 ??
etc

you could put in D2:

=IF(ISERROR(MATCH(TRIM(VLOOKUP(A2,MyTable,2)&VLOOK UP(B2,MyTable,3)&VLOOKUP(C
2,MyTable,4)),TRIM(Sheet1!$B$1:$B$8&Sheet1!$C$1:$C $8&Sheet1!$D$1:$D$8),0)),"
",INDEX(Sheet1!$A$1:$A$8,MATCH(TRIM(VLOOKUP(A2,MyT able,2)&VLOOKUP(B2,MyTable
,3)&VLOOKUP(C2,MyTable,4)),TRIM(Sheet1!$B$1:$B$8&S heet1!$C$1:$C$8&Sheet1!$D$
1:$D$8),0)))

Array-enter the formula in D2, and fill down

Col D will return: 1c, etc
depending on the source numbers in cols A to C
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----