Need an indicator column - not using IF statement??

Hello,

Instead of doing a complicated nested IF statement I hope one of you genius's may provide a more elegant solution

I have a column of school ID numbers and I want to create another column to specify one of the following

Primary (starts with 2 or 3)
Secondary (starts with a 4)
Special (starts with a 7)
PRU (starts with a 1)

One of the schools is unique as it has both primary and secondary children. So all children who are Year 7 or above are secondary and all others are primary.

Any ideas?

Thanks

Thanks, for some reason the LEFT function returned a text value even though the IDs are numerical.

So I amended it to VALUE(LEFT(A2,1)) so that is fine.

The age is in a separate column so I have created the following

=IF(AND(A2=4505,B2>6),"Sec",IF(A2<>4505,LOOKUP(VALUE(LEFT(A2,1)),{1,2,3,4,7},{"PRU","Pri","Pri","Sec","Spe"}),"Pri"))