Find first value in column 2x current value and return value in column next to it

[bjcowen9000]

I have an excel spreadsheet. I have column C which has price values. In column D, I have the date. In column E, I want to return the first time the current price reaches is doubled.

So for example, if C1 is $1 and the first time column C gets to $2 is C27, then I would want to return the date of E27 to E1. Note that the range lookup has to change. For instance, for C2, we don't want to look at C1 to see if the price is doubled. Basically, we cannot go back in time. Can anyone help with this? I tried using vlookup, but it is not working as I would like. It seems like its missing some values because it isn't exactly 2x.

[dosydos]

IF you are only looking for the first time the price = Doubled, and not the first time the price >= doubled then put this formula in E1
=VLOOKUP(C1*2,$C2:$D$1000000,2,0)

[Ace_XL]

Try in Cell E2

=INDEX($D2:$D$100,MATCH(C2*2,$C2:$C$100,0))

Copy down