Hi Howard,
If you're a bit lost I've been wandering the desert for 40 days and 40 nights!
Think I may have got lost somewhere when you used different cell references
to the ones I put in my example. I managed to get the thing to work 'sort of'
but there was obviously something I was missing. Tried lots of variations as
well but couldn't stumble on the right combination
Anyway no problem as I've tried Max's fix and it works whatever the table
values I use so question solved, but thank you very much for taking the time
to help.
Sorry I'm obviously not quite bright enough to use the help sometimes!
Thanks again,
Steve.

"L. Howard Kittle" wrote:

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.