Group Aging Value

[Thomas Kuriakose]

Respected Sirs,

Kindly find attached a list of aging values which need to be grouped as below -

GroupsValue
0-301
31-602
61-903
91-1804
181-3655
>365 6


Kindly let me know how we can get these values and groups mapped with the aging.

Thank you very much,

with regards,
thomas

 

[Nebu]

Hi:

This formula?

=LOOKUP(A2,{0,31,61,91,181,366},$E$2:$E$7)

Thanks

 

[Thomas Kuriakose]

Respected Sir,

Thank you very for this solution.

Kindly advise on formula for value in C2.

Thank you very much,

with regards,
thomas
t

 

[Nebu]

Hi:

Give a simple Vlookup based on the value you got in B2 for C2 figure.

Thanks

 

[bosco_yip]

C2, copy down :

=MATCH(A2,{0,31,61,91,181,366})

Regards

 

[Thomas Kuriakose]

Respected Sirs,

Thank you very much for the solution provided.

Much appreciated.

with regards,
thomas