Ssheet has SP500 values by month back to 1950. 2 VBA's needed =
(1) If client would have invested i.e... Jan 1990 (01, 1990) , Lookup will return the SP500 value at that date.
(2)nd Lookup will return every Jan value (01 - 1991 --> 2006) after that date.
Need to be able to choose a month (1-12) and year (1950-20050 of any choice...
Your Help greatly appreciated. thanx dollardoc
Bookmarks