"IF" with names?
Posted by Dwight on December 07, 2001 6:32 AM
Column A has initials of people assigned to accounts. Each individual is in one of two groups (in future may have more groups, will never have more than 9 individuals in any group). I would like a formula in column B which shows which group the assigned individual is in, eg if "JDR", "RJR" and "TMP" were the members of "Group1" entering "JDR" in cell A3 would make "Group1" appear in B3, and so on.
I think I know how to do nested IF but I think I already have too many names (12 total) and will be adding more in the future. Any ideas?