If formula with text strings!

[almst791]

Can someone make me a formula to display the following. I have a column of numbers in row a so a1=7500300 and I want column be to have a function to tell that it is FA - Indirect. Is there any if statement that can handle the following requirements?

75XX3xxx = FA - Indirect
75XX7xxx = FA - R&D
75XX4xxx = FA - Sales & Marketing
75XX5xxx = FA - Sales & Marketing
75XX6xxx = FA - Admin
7XXX = FA - DGP

 

[Tetra201]

Try this formula:

=IF(LEN(A1)<=4,"FA - DGP",IFERROR(CHOOSE(MID(A1,5,1)-2,"FA - Indirect","FA - Sales & Marketing","FA - Sales & Marketing","FA - Admin","FA - R&D"),""))