Hello,
I am trying to use a drop down list to return a table of data. I have monthly returns for three stock market indices (S&P 500, MSCI EAFE, MSCI EM), and I want to be able to select one of those indices from the list in a drop down menu, which will then return the monthly dates and returns columns. Please see my sample data which has the 4 columns: Date, S&P 500, MSCI EAFE, MSCI EM:
Date S&P 500 MSCI EAFE MSCI EM
12/30/2005 1.00% 1.00% 1.00%
1/31/2006 2.00% 2.00% 2.00%
2/28/2006 3.00% 3.00% 3.00%
3/31/2006 1.00% 1.00% 1.00%
4/28/2006 2.00% 2.00% 2.00%
5/31/2006 3.00% 3.00% 3.00%
My goal is to select "S&P 500" from my drop down menu, and it will return all data in Columns A (Date column) and B (S&P 500 Returns column), which would be six months of returns with their respective dates.
I appreciate any help that somebody can provide. I went through forums for a long time but was unable to find my exact issue.
Thanks.
Bookmarks