I am working on a spreadsheet for work. We currently have all of our rate cards for our different vendors organized by "Rate ID". Each of the rate ids starts with an abreviation for a city. NYC for New York, SAT for San Antonio, etc. Different regions are managed by different people. A region contains many cities. What I am looking to do is add a new column for regions. There are hundreds of different cities though. I need a formula that will allow to do this. I need something like, if the first 3 in the rate id column are NYC then northeast in region column.