Sorting data in Google sheets. How to assign a value?

Question

JavaScript

I collect registrations in a Google spreadsheet, when registering, people choose the region of the Russian Federation from the list (about 70 regions)
I need to sort them by region (not region). There are only 6 regions.
If I make a list - which regions are included in which region, how can I automatically substitute the region for the answers? Or replace the area value with the region..

Answer 1

Give an example of a table. The vlookup
formula will help to substitute the value , for example