I am having a devil of a time figuring out how to accomplish this lookup.
I have one sheet with the name of each month and along side I want to display a value based on a lookup on a second sheet.
Logic wise I would:
1. Get month on sheet 1
2. Find all start dates that occur during the select month
3. get the Total for the last entry for the selected month
Capture.PNG
In the screenshot if you note the Start Dates are in chronological order but not the end dates. For simplicity I put the sample data all on the same sheet.
Any suggestions, I have been looking at MAX and VLOOKUP but not really working out too well.
Bookmarks