Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup in aging
it's been a long day and i know this is simple to do, but i think i am burned
out: =VLOOKUP(J2,{0,"0-30";30,"60";61,"120";121,"180";181,"300";241,"300" ;301,"365+"},2) need to be able to carry over to my pivot joe |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup in aging
As-is, your formula looks ok in creating the "buckets" text labels col for
your pivoting. It returns the required text label ("bucket descript") depending on the numerical values in J2 down. Maybe just add a simple front IF check for blank cells and do an "add zero" to the lookup values in J2 down (J2+0, instead of J2) to coerce any text numbers in col J to real numbers: =IF(J2="","",VLOOKUP(J2+0,{0,"0-30";30,"60";61,"120";121,"180";181,"300";241,"300" ;301,"365+"},2)) Joy? hit YES below -- Max Singapore --- "JoeM" wrote: it's been a long day and i know this is simple to do, but i think i am burned out: =VLOOKUP(J2,{0,"0-30";30,"60";61,"120";121,"180";181,"300";241,"300" ;301,"365+"},2) need to be able to carry over to my pivot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aging Report | Excel Discussion (Misc queries) | |||
AGING | Excel Discussion (Misc queries) | |||
aging formula | Excel Discussion (Misc queries) | |||
aging | Excel Worksheet Functions | |||
aging of invoices | Excel Worksheet Functions |