Categorize set of number into different group

[metric]

I've begginers knowledge in excel, Please assist me with the problem am facing, It's something like that.
I have different sets of number from six digits to a max of 15 digits
eg.
012345
001005869
Z000000A
K1234567
CF0000009
K880000000
M000000123
Y001234505
AL56231
5649852A
What I want is to get the proper category for this number depending upon there digit for eg.
number starting with Z and of 8 digits belongs to group A
number staring with Y ending with 5 and 10 digits belong to group B
number ending with A and which does not starts with any alphabet has 8 digits belongs to group C.
similary ...
A user need to just key in the number, press tab (or any other button) and group for that number
must be displayed (depending upon the compostion of that numbers).

What I can think of is to first seprate each digits from the given number, verify it and then filter them through the groups to get the final group.
However I don't have any idea about how to go about doing this

or are there some more better ways for getting this done, Please assist

 

[metric]

Is there a way we can get the output Group A, Group B, if the condition is satisfied, I mean Group A, Group B and so on instead of TRUE and FALSE.

Thanks for the help , It seems that the AND OR thing will help out,

Once again thank you all of your for your suggestions.

metric

 

[metric]

Please give me a hint, if the above is possible

Thanks,
metric

 

[PA HS Teacher]

For a given row,
Assuming your True/False values are in Columns B through say, Z,
and your group Names are in Row 1.

In an unused Column.
=Index(B$1:Z$1,Match(True,B2:Z2,0))