Hi
Excel 2003
As per the example created below I'm using a formula to return a number
value (in D1) that can be anywhere between 0.00 & 6.00 (including 0.00 & 6.00)
I want my formula (in E1) to compare the value (D1) to min & max values in a
table (A4:A9), so whichever min & max my value equals or falls between, it
will return the value in a 3rd cell adjacent the appropriate min & max
cells(C4:C9) :

A B C D E
1 4.75 Pink
2
3 Min Max
4 0.00 0.99 Blue
5 1.00 1.99 Green
6 2.00 2.99 Yellow
7 3.00 3.99 Red
8 4.00 4.99 Pink
9 5.00 6.00 Orange


My calculated value is in D1
The formula (in E1) needs to compare D1 with the table in A4:B9
then return the corresponding value (colour) from C4:C9 and place it in E1

Hope my explanation is clear enough, thanks for looking & hope you can help.
Cheers.