I'm a bit lost on what's going on.

If you want, send me an example workbook and detail what and where you want
to happen. Send to:

lhkittle at comcast dot net (loose the spaces and convert the "at" and
"dot")

May not be able to fix it but will try.

Regards,
Howard

"Struggling in Sheffield"
wrote in message ...
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.