vlookup, index-match

[Ronald Cayne]

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

 

[Niek Otten]

With your table in A1:B11 and the data to lookup in C:

=VLOOKUP(A13,$A$1:$B$11,2)

Your boundaries don't seem to be consistent: <30, 31-60 What about 30?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Niek Otten]

OOPS!

=VLOOKUP(C1,$A$1:$B$11,2)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel