RE: No subject was specified.
- From: "David" <David@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 30 Apr 2005 08:52:05 -0700
Hi,
The essence of the Vlookup is how you set up the lookup value and seeting
the Lookup to True. You will have to adjust for the Column differences, but
you need something like this:
col x col xx
0 < 30 days 154 151-180 da
30 31-60 da 139 121-150 da
60 61-90 da 164 151-180 da
90 91-120 da 189 181-365 da
120 121-150 da 1825 >5 yrs
150 151-180 da 199 181-365 da
180 181-365 da 236 181-365 da
365 1-2 yrs 120 121-150 da
730 2-3 yrs 65 61-90 da
1095 3-5 yrs 299 181-365 da
1825 >5 yrs 284 181-365 da
=VLOOKUP(C16,$A$16:$B$26,2,TRUE) <-----This is the formula you need in the
lookup. The number in the first column is a number equal to number of days,
there is a little tweeking to be done, but I am sure you will be able to do
that.
Thanks,
"Ronald Cayne" wrote:
> 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
>
>
>
.
- References:
- No subject was specified.
- From: Ronald Cayne
- No subject was specified.
- Prev by Date: using listboxes as input
- Next by Date: Re: No subject was specified.
- Previous by thread: No subject was specified.
- Next by thread: Re: No subject was specified.
- Index(es):
Relevant Pages
|
