So under one tab labeled "scores" I have data that looks like this:
12/16/13 ETF-J
12/9/13 ETF-F
12/2/13 ETF-G
and in a separate tab I have data that looks like this:
ETF-J ETF-F ETF-G
1 yr Returns
12/16/13 .87 .67 .45
12/9/13 .05 .35 .04
12/2/13 .67 .23 .24
what I am looking to do is write a formula that would return the number associated with the given ETF and date so the first tab labeled "scores" would look like this:
12/16/13 ETF-J .87
12/9/13 ETF-F .35
12/2/13 ETF-G .24
Any help would be greatly appreciated !!!!!
and sorry about the formatting there is much data in between that dates and values so I could not simply copy/past
Bookmarks