software

A B C D E
F
1 Qty Coupon Maturity 2006 2007
2008
2 100 4.38% Jan-2007 4,375.00 102,187.50
3 50 4.85% Sep-2008 2,425.00 2,425.00
51,212.50
4 50 4.00% May-2008 3,750.00 3,750.00
51,875.00
5 -----------
------------- ------------
6 Prinicipal Paid 0 100,0000
100,0000

How to match maturity year (col c) with table year (row 1) and return
principal paid sum (row 6, col E,F,etc....). I don't know what formulas to
use (array, lookup, etc.) nor how to construct it.

For row 2

=INDEX(D2:F2,MATCH(YEAR(C2),D1:F1,0))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;RlzGainquot; gt; wrote in message
...
gt; A B C D
E
gt; F
gt; 1 Qty Coupon Maturity 2006 2007
gt; 2008
gt; 2 100 4.38% Jan-2007 4,375.00 102,187.50
gt; 3 50 4.85% Sep-2008 2,425.00 2,425.00
gt; 51,212.50
gt; 4 50 4.00% May-2008 3,750.00 3,750.00
gt; 51,875.00
gt; 5 -----------
gt; ------------- ------------
gt; 6 Prinicipal Paid 0 100,0000
gt; 100,0000
gt;
gt; How to match maturity year (col c) with table year (row 1) and return
gt; principal paid sum (row 6, col E,F,etc....). I don't know what formulas to
gt; use (array, lookup, etc.) nor how to construct it.