Forum Discussion

Copper Contributor

Dec 27, 2021

Vlookup by date/time in pivot table

hi i'm trying to lookup a value in a pivot table by date/time in previous month and am only getting the top value from the column. how do i add time to the eomonth function or date/time to vlookup, h...

excel

Formulas and Functions

TmurphyASC

Copper Contributor

Dec 27, 2021

yes i thought that might work so i went to 13.5 but it comes back with NA. i know i'm in this month because i just started generating my data this month but in January I'm hoping to use this function to generate a report. thankyou HansVogelaar

HansVogelaar

MVP

Dec 27, 2021

TmurphyASC

Could you attach a small sample workbook without sensitive/proprietary information?

TmurphyASC
Copper Contributor
Dec 27, 2021
i would be glad to but i dont see a way to add attachmentsHansVogelaar
- HansVogelaar
  MVP
  Dec 27, 2021
  TmurphyASC
  
  If you don't see an area below the box where you compose a reply that says "Drag and drop here or browse files to attach", you could upload the workbook to a cloud service such as OneDrive, Google Drive or Dropbox, then obtain a link to share the uploaded file, and paste the link into your reply.
  - TmurphyASC
    Copper Contributor
    Dec 27, 2021
    https://aquasierra-my.sharepoint.com/:x:/p/tmurphy/ER4cESXadmtLtoRW8P_Msx8BNwha5-zhFwlGm8dMEIo-aA?e=4IfCet
    HansVogelaar