Hi,

I have the following entered to set a text value in column d when some other
text value is found in a cell range within columns b and c:

=IF(COUNTIF(B49:C49,"*aaa*")0,"mgr1",IF(COUNTIF(B 49,"*bbb*")0,"mgr1",IF(COUNTIF(B49,"*ccc*")0,"mg r1",IF(COUNTIF(B49,"*ddd*")0,"mgr1",IF(COUNTIF(B4 9,"*eee*")0,"mgr2",IF(COUNTIF(B49,"*fff*")0,"mgr 2","Other"))))))

This works as intended for any value containined in cells of column b, but
only works for the very first value ("aaa") in column c. In other words, if
the value of a cell within range for column c is "bbb", "Other" is returned
instead of "mgr1".

Can anyone tell me what I am doing wrong? Is there a way to have the
formula evaluate each value for both columns?

Thanks,

Tom