MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

Posted by Aladin Akyurek on December 07, 2001 6:43 AM

Hi Dwight,

Create a sheet, name it Admin. In Admin create a 2-column list consisting of:

JDR Group 1
AA Group 2

select all of the cells of this list and name it eg TEAMS, then use


to retrieve the group in B.



Posted by Dwight on December 07, 2001 11:37 AM

Perfect solution as usual. Thanks, Aladin. NT