What is the best approach to completing col xx. vlookup? nested if's.
Column X represents no. of days. column xx represents the aged grouping.

I

TABLE col x col xx
0 "< 30 days" 154 "151-180 da"
30 "31-60 da" 139 "121-150 da"
60 " "61-90 da" 164
90 "91-120 da" 189
120 "121-150 da" 1825
150 "151-180 da" 199
180 "181-365 da" 236
365 "1-2 yrs" 120
730 "2-3 yrs" 65
1095 "3-5 yrs" 299
1825 "5 yrs" 284
731
23
359
384
369
555
181