IF Function - Multiple Conditions

[jdavidson]

Hi,

I have a column of numbers (N2:N351) and I need to indicate in the next column what department these numbers belong to. I have three "types" of numbers, they are grouped into number strands that start with 3,4 and 5. So therefore, if for example, the number is 34558363, it needs to display PS in the cell beside it in column O. I wanted to know if anyone can tell me how to use a wildcard and also use multiple conditions so that if the number is 3* then PS, if it's 4* then COS, and if it's 5* then AB. Any help would be appreciated.

Josh

[daddylonglegs]

=Try this formula in O2 copied down

=LOOKUP(LEFT(N2)+0,{3,4,5;"PS","COS","AB"})

[snasui]

Another,

O2

=Choose(Left(N2)-2,"PS","COS","AB")

Enter and copy down.

Hope this helps.