You might try the help index for
LOOKUP.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.