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!
Bookmarks