always feels good to come back to Mr. Excel, feels like I'm learning something new.
Anyways, I have a master sheet of accounts with a state they are located in.
On another sheet I have an engineer assigned and multiple states they will cover for those accounts.
Sheet 1
Company A, CA, insert...