+ Reply to Thread
Results 1 to 4 of 4

Search formula to find intersection of column and row

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    3

    Search formula to find intersection of column and row

    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

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Search formula to find intersection of column and row

    You need an index formula like this: INDEX(range,MATCH(day,range),MATCH(year,range))

  3. #3
    Registered User
    Join Date
    06-15-2012
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Search formula to find intersection of column and row

    It worked! Thanks Cutter!

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Search formula to find intersection of column and row

    You're welcome. Please mark your thread as SOLVED (click on Forum Rules @ top of page to see instructions in rule #9).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1