Replace data

Replace data

We have realigned the states our sales people have. I want to make bulk changes to the record manager field to reflect those changes. I need to be able to make the change based on state. Example: If the state is Illinois, then the record manager is Bob. What is the best way to accomplish it?