Assigning a cell to a certain name

[Succeeding4]

I am trying to take a column with aging numbers and assign them to categories, so for instance I have tasks that are past due and I want to show the number of days within groups like 0-30 days, 31-60 days etc...how do I do that?

 

[JugglerJAF]

Create a lookup table with the required days and use XLOOKUP 9or VLOOKUP) to return the closest match.

Book4
	A	B	C	D	E
1	days aged	aging (lookup)		days	aging
2	0	0 to 30 Days		0	0 to 30 Days
3	10	0 to 30 Days		31	31 to 60 Days
4	29	0 to 30 Days		61	61 to 90 Days
5	30	0 to 30 Days		90	91 to 120 Days
6	31	31 to 60 Days		121	121+ Days
7	45	31 to 60 Days
8	60	31 to 60 Days
9	61	61 to 90 Days
10	88	61 to 90 Days
11	90	91 to 120 Days
12	91	91 to 120 Days
13	110	91 to 120 Days
14	120	91 to 120 Days
15	121	121+ Days
16	150	121+ Days
17	170	121+ Days
Sheet1

Cell Formulas
Range	Formula
B2:B17	B2	=XLOOKUP(A2,$D$2:$D$6,$E$2:$E$6,,-1)

 

[Succeeding4]

Thanks!