Maybe
=LOOKUP(E2,{"Blue","Red","Green","Yellow"},{1,2,3, 4})
Mike


"Murph" wrote:

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.