Write another VBA function called =YRMO that will turn a date into the year and month, such that 12/8/14 would return: 2014.12
This is useful for tagging dates so that you can aggregate information in a long list into monthly buckets.
Do the following readings:
1. From the VLOOKUP Book, please read the pages 1-24.
2. From the course reader: please read Benjamin Graham’s Intelligent Investor, Chapter 16: “Margin of Safety” as the Central Concept of Investment.
You may want to watch the following videos:
This video on the =LOOKUP function is pretty useful, especially towards the end.
Excel Lookup Series #7: LOOKUP Function
And this video is very long, but provides a lot of examples that go far beyond the basics of =LOOKUP. Watch any parts that you’re interested in.
LOOKUP function Beginner to Advanced 23 Examples (Excel VLOOKUP WEEK Video #2)
It would be a good idea to spend some time on Lynda.com:
In the course: Excel 2013: Advanced Formulas and Functions with Dennis Taylor, watch the first three videos about LOOKUP functions.