I have a table that looks like the below.
Currently, I have to manually enter data into cell F5 from data from the chart below. I need a formula lookup the CUSIP and return data from the month/year for that security. This is only a sample set of data.. There are 50 securities I have to do this for. The data chart below has to be displayed that way since they are generated from data feeds and go across for 50 securities.
Any help is appreciated.
Thanks.
Tony
bb bond data 02282009.xls | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
4 | 02/28/09 | ||||||
5 | 31394U4L3 | FNM05099AF | 103,333,333.00 | 61,047,515.50 | |||
6 | 31395DUX5 | FNM06042PF | 135,000,000.00 | 89,288,725.95 | |||
7 | 31395NCU9 | FNM06044FP | 260,000,000.00 | 166,083,889.40 | |||
Summary |
Currently, I have to manually enter data into cell F5 from data from the chart below. I need a formula lookup the CUSIP and return data from the month/year for that security. This is only a sample set of data.. There are 50 securities I have to do this for. The data chart below has to be displayed that way since they are generated from data feeds and go across for 50 securities.
bb bond data 02282009.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | 31394U4L3 | 31395DUX5 | 31395NCU9 | |||||||
2 | 31394U4L3Mtge | 31395DUX5Mtge | 31395NCU9Mtge | |||||||
3 | MTG_HIST_FACT | MTG_HIST_FACT | MTG_HIST_FACT | |||||||
4 | 3/25/2009 | 0.58176088 | 3/25/2009 | 0.64819616 | 3/25/2009 | 0.62481068 | ||||
5 | 2/25/2009 | 0.59078241 | 2/25/2009 | 0.66139797 | 2/25/2009 | 0.63878419 | ||||
6 | 1/25/2009 | 0.59460328 | 1/25/2009 | 0.6693372 | 1/25/2009 | 0.64863839 | ||||
Factor |
Any help is appreciated.
Thanks.
Tony