Sort from one matrix, then lookup and assign corresponding value

[spnpls]

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

[WHER]

See if the attachment does what you're looking for.

[beaunydal]

If it is possible that there could be duplicate values in different rows of the days matrix then attached doc has a method that can handle such duplicates.