I am attempting to fill in data on one tab that is based on a date (Month and Year). THe data is pulled in from the web and I believe a formatting issue is preventing a vlookup from working - any ideas? The Price for 12 mo period is where I want to enter the desired start date and the actual data is on the Price by date tab. I've added notations that help to explain on the attached, you can ignore the other tabs.
Bookmarks