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),$D$1:$F$1,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.