Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup, index-match
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup, index-match
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 "Ronald Cayne" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup, index-match
OOPS!
=VLOOKUP(C1,$A$1:$B$11,2) -- Kind Regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... 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 "Ronald Cayne" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/Match or Vlookup | Excel Worksheet Functions | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
Need Help with Index and Match or Vlookup | Excel Worksheet Functions | |||
Index Match Vlookup or something else | Excel Discussion (Misc queries) | |||
VLookup or Index Match ? | Excel Worksheet Functions |