Lookup Results by selected MONTHS/YRs...
 

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) , Looku
will return the SP500 value at that date.

(2)nd Lookup will return every Jan value (01 - 1991 -- 2006) afte
that date.

Need to be able to choose a month (1-12) and year (1950-20050 of an
choice...

Your Help greatly appreciated. thanx dollardo

--
dollardo
-----------------------------------------------------------------------
dollardoc's Profile: http://www.excelforum.com/member.php...fo&userid=3724
View this thread: http://www.excelforum.com/showthread.php?threadid=56958