Lol............sorry, it was past my sleepy-time............thanks for
catching it Max........
here's the formula, depending on how it's spelled <g

=IF(A1="cherry bed","0042","")

....and of course a VLOOKUP could be used instead if there were many
"phrases".

Merry Christmas to all............

Vaya con Dios,
Chuck, CABGx3



"Max" wrote in message
...
"CLR" wrote:
This formula , if put in the next (or any) cell will display 0042 if a1
contains cherry red

Chuck, think you forgot to paste the formula ? <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---