I think you are looking for this...

=MATCH(F2,{"blue","red","green","yellow"},0)

Rick


"Murph" wrote in message
...
I'm just not computing this simply in my mind. I want a formula/macro that
will check cell F2 for multiple terms (blue, red, green, yellow) then
input a
number in cell G2 to reflect that color (blue = 1, red = 2, green = 3,
yellow
= 4).

I have not had enough coffee today obviously because this seems like a
simple task and I'm just not grasping it. Excel 07 also.