Hi there,
I'm new at this forum so please bear with me. I keep a worksheet with bond rates - the columns are maturity years 1-30 labeled 2013, 2014...2042. The rows are each business day of the year, 3-Jan-12, 4-Jan-12, etc.
I need a formula that I can use on a separate worksheet that will find the bond rate of a particular maturity year on a given date.
I've tried combining V and H Lookup, Match, Index, Offset, etc. clearly I have no idea what I'm doing. Can someone please help me?
Thanks,
Parky58
Bookmarks