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