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

R

RlzGain

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.
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top