Hello All,
I am trying to create a sheet that will automatically assign people to a room based on their last name. I think that I am overthinking this and that it is a simple formula, but I can not figure it out. The names are in column a and in column b I want it to automatically assign the room based on their last name. Everyone with the last name that starts with A-BL goes in room 1, Last names starting with Bo-BZ go to room 2, ect. Here is an example of what I am trying to do.
Any help would be greatly appreciated. Thank you.
I am trying to create a sheet that will automatically assign people to a room based on their last name. I think that I am overthinking this and that it is a simple formula, but I can not figure it out. The names are in column a and in column b I want it to automatically assign the room based on their last name. Everyone with the last name that starts with A-BL goes in room 1, Last names starting with Bo-BZ go to room 2, ect. Here is an example of what I am trying to do.
Name | Room |
Allen, Robert | 1 |
Bisson, Lucas | 2 |
Ben, Tyler | 1 |
Any help would be greatly appreciated. Thank you.