0

Deleted

Jet Reports Historic Posts

June 02, 2011 11:22

None

Follow

Deleted

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts June 02, 2011 16:15

  Hi Kyle,
  
  There is no way to prevent the Report Options from quoting your value. However, I believe you can just wrap the value in the Excel VALUE function in your VLOOKUP function which will turn it from a string into a numeric value. So I assume what you are doing is doing a VLOOKUP on the period number from the options sheet and looking up the period date range on the Period sheet. In this case, your VLOOKUP formula might look like this:
  
  =VLOOKUP(VALUE(Options!$D$7),Periods!$C$11:$F$22,4)
  
  Does that work for you?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts November 29, 2011 16:52

  We just upgraded our Jet, and many of our reports are now broken because the old Jet took the values from a vlookup.
  
  I tried the VALUE formula on a date, but it returns my Option entry to a "0" value rather than the Julian date value I had hoped for. Any other suggestions for getting this to function? Did the OP find a solution?
  
  *********************
  EDIT
  *********************
  
  I solved for it by setting up Option fields for Month, Day, and Year, then used an Excel DATE formula to put the dates together (not using VALUE) in another cell for the Vlookup to pull from.