Returning Text from a group of cells based on the value of another cell

[pwi...@global-aero.com]

Hello:

I hve a spreadsheet that looks like this

Class Limit

1,500
1,750
1,000
2,000
1,500

and a small table the looks like this

< 500 Class l
> 500 - <1,000 Class ll
>1,000 - <1,500 Class lll
> 1,500 Class lV

I want to populate the class section in the first small table based on
the limit in the cell next to it using the small data table above.
FYI - I have the >500 - <1,000 data in one cell.

Thanks
Cheetah

[pwi...@global-aero.com]

[AndrewArmstrong]

Cheetah,
What happens at the limits of the range, for example 1500? I assumed
next class higher.
Also, the values in the table should be input in a manner like:
For class I
="> "&"500" so that the numeric value can be changed, if need be
For class II
="> "&"500"&"-"&"<"&"1000"
and so on, for the other classes

You can than use this formula (watch out :) ) to search though the text
and find the values for the ranges, this is in cell A2 with the limits
in column B

=IF(B2<VALUE(MID($D$7,(SEARCH(">",$D$7,1)+1),10)),"Class
I",IF(AND(B2>=VALUE(MID($D$8,(SEARCH(">",$D$8,1)+1),((SEARCH("-",$D$8,1)-1)-SEARCH(">",$D$8,1)))),B2<VALUE(MID($D$8,(SEARCH("<",$D$8,1)+1),10))),"Class
II",IF(AND(B2>=VALUE(MID($D$9,(SEARCH(">",$D$9,1)+1),((SEARCH("-",$D$9,1)-1)-SEARCH(">",$D$9,1)))),B2<VALUE(MID($D$9,(SEARCH("<",$D$9,1)+1),10))),"Class
III",IF(B2>=VALUE(MID($D$10,(SEARCH(">",$D$10,1)+1),10)),"Class
IV","ERROR"))))

Hope this works for you!

Andrew J Armstrong