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

HansVogelaar

MVP

Dec 27, 2021

TmurphyASC

Perhaps

=VLOOKUP(EOMONTH(TODAY(),-1)+13.99999,A:E,5)

By the way, EOMONTH(TODAY(),-1)+13 is the 13th of the current month (i.e. December 13, 2021 as I write)

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.