[SOLVED] Quick question: Time it takes to reach a temperature?

[Romoko]

Hello! What a great forum, has helped me many times.

I have two columns of data, D and E with time in the E column and rising temperatures in the D column.
My question is that I would like to the find the time between when column D exceeds 30 and when it reaches a value like 150 by referencing the time column E.

I solved this using the VLOOKUP function: =(VLOOKUP(150,D12:E400,2,TRUE))-(VLOOKUP(30,D12:E100,2,TRUE))
However, I had to move my time variables from column C to E in order for VLOOKUP to work. (It won't accept a lookup value of -1 for the column designation)

Is there another way to do this?

Thank you in advance!

[FDibbins]

=index(match()) will do a "negative" lookup for you. try this 1, you may have to play around with the references

=INDEX(D13:E19,MATCH(I12,E13:E19,0),1)

[FDibbins]

thinking about it again, there may be another way. can you upload a sample worksheet?

[martindwilson]

as long as data in d is in ascending order use lookup
lookup(d12:d100,c12:c100)

[Romoko]

=index(match()) will do a "negative" lookup for you. try this 1, you may have to play around with the references

=INDEX(D13:E19,MATCH(I12,E13:E19,0),1)

This worked like a charm. Thank you

Here is what I changed to make it work for my application (just in case anyone else needs it)

=(INDEX(C13:D400,MATCH(150,D13:D400,1),1))

and here is the full formula i used in the cell:

=(INDEX(C13:D400,MATCH(150,D13:D400,1),1))-(INDEX(C13:D35,MATCH(30,D13:D35,1),1))

Thanks again. + rep