If condition for a range of alphabetic corridors

[Anonymous]

Hello all. 

I have a column that represents a warehouse location like 1PA22AA, which 1 represents the floor, PA represents the corridor, 22 is the location inside the corridor and AA the shelf.

I have separated between different columns the floor and the corridor (PA in this case) and it is all that matters for me.

I need to group a bunch of corridors to a condition like if the floor is 1 and the corridors goes from AA to BA (AA, AB, AC, ... BA) is zone 1, and so on. 

How can I write an if function without have to specify all the corridors like AA, AB, AC, and so on?

Thank you!

[Anonymous]

@Anonymous Not sure what kind of source you have. But is it possible to create a reference/lookup table with all possible combinations and join it here. to get the required outcome.