Create a 2 column table with the cild codes in the left column and the
corresponding parent codes in the right column:

...........A..........B
1......100.......Y02
2......101.......Y02
3......ABB.....Y02
4......111.......Y01
5......AAA.....Y01

Fill in *all* of the codes.

Then...

D1 = input cell = 111

Formula in cell E1:

=VLOOKUP(D1,A1:B5,2,0)

--
Biff
Microsoft Excel MVP


"cangiff" wrote in message
...
I am trying to do something that I am sure is very simple to achieve, but
it
is beyond my limited knowledge i.e.

I have a list of 100 3 digit codes that can be alpha/numeric.

Each code represents the aggregate of of another series of 3 digit codes
that can also be alpha/numeric e.g.

Parent Y01 is total of children codes in ranges 111 - 120, AAA-AAE
Parent Y02 is total of children codes in ranges 100-110, 131-140, ABB-ABF
Parent Y03 is total of children codes in ranges 121-130, 141-150, AAF-ABA

I would like a formula that will return which parent code applies for any
given child code i.e.

Input: Child code = 111
Output: Parent code = Y01

Can anyone suggest a solution?

cangiff