Number of days it took a stock to rise/sink above a certain level.

[CLIFFEAT14048]

I tried to use multiple IF formulas, but it got too complicated for me and I also couldn't get them to work. I am using Excel 2013, 64-bit. I'm not positive that my explanation fully explains what I am trying to do, so it's probably better to look in file 1.


1. In 'FILE1', find if stock in A1 is found in column A in 'FILE2', if so:
2. In 'FILE1', find if date in G1 is found in column G after G1 is in 'FILE2'
3. H1<I1 - this determines whether to buy/sell (can H1>I1 be used in same formula?)
4. If conditions are met, add B1+1, then insert how many days this took in columns J-S.
Thanks for any help,
Cliff