Thread: vlookup in aging
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JoeM[_3_] JoeM[_3_] is offline
external usenet poster
  
Posts: 33
Default 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
Reply With QuoteReply With Quote