Hi,
I have got two matrices, which i will describe below, and after that i'll post my problems:
Both matrices has got numbers vertically, and names horizontally:
3month 6 month 9 month 1 year This is the first matrix referring
1 177 177 181 179 to days
2 250 251 263 221
3 290 296 296 289
This first matrix allows values like 177 to repeat itself, as long as it is in the same row
3month 6 month 9 month 1 year This is the second matrix referring
1 0,05 0,05 0,05007 0,05004 to rates
2 0,06 0,06002 0,0601 0,0595
3 0,07 0,0705 0,0705 0,0699
As long as two parallell columns have the same values (177,177), and (296,296), they will also have the same corresponding number in the second matrix.
What i need, is a way to extract numbers from the first matrix, into a column, sorted increasing, like this:
Day
177
179
181
221
250
251
263
...
Then i need a second column, next to the first column, assigning the correct rates to the days:
Day Rate
177 0,05
179 0,05004
181 0,05007
221 0,0595
250 0,06
251 0,06002
263 0,0601
. .
. .
. .
Note: as the day 177 is mentioned twice in the first matrix, I still just need it once in my pair of columns.
I've tried a range of different lookup, small, if's and so forth, but still cant find something that works.
I'd be very happy if someone could post a solution to this problem
Bookmarks