Index, Match, Offset Formula

In A27:B56 there are a ticker and date for each example and in D27:D56 there is a duration. I am trying to write a formula that matches the ticker and date for each example with the ticker and date in A369:A397 and I369:I397.

If a ticker and date match can be found then return % that corresponds to the duration #.

For example:

Ticker: LCC Date:5/25/2010 Duration=5

The ticker and date matches with LCC in A369 and 5/25/2010 in I369 so return the 5th number in row 369 which would be -9.03%

I need to be able to drag this formula from E27:E56

Anyhelp would be great!

Given your use of XL2007 you might find it simplest to use a SUMIFS construct, eg:

E27:
=IF(ISNUMBER($D27),SUMIFS(INDEX($R$369:$BX$397,0,$D27),$A$369:$A$397,$A27,$I$369:$I$397,$B27),"")
copied down

the SUMIFS will return 0 by default where no match is found - ie nothing to sum