i need help with a lookup and/or array type formula

[Guest]

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.

 

[Bob Phillips]

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)