I am trying to create an "IF" function that will use the text entered in a
previous cell to fill in the current cell. I am doing this to break the US up
by state regions. I am trying to get diffrent managers to fill in for
diffrent states that are entered. (i.g.
=if(or(l2=€�mi€�,l2=€�in€�,l2=€�oh€�,l2=€�k y€�,l2=€�ny€�),€�Ganiard, Tom€�,"")
this will work for one manager."Ganiard, Tom" is what i want added for cells
that have the abbreviations for the sates above. now i want to add more
possible account managers for diffrent states but in the same cell.

Can anyone help me?