When column value is reached return contents from adjacent cell

[will.sf]

Hi, I'm trying to find a formula so when the value in a table from column A "Temperature" goes above 35, the value in the same row but from table column B "Pressure" is returned?

While this is a simplified example, the actual data will have many rows and columns. The indicated rows may not necessarily be next to each other.

Any help would be appreciated.

[mehmetcik]

Will. Do you have 365?

=INDEX(Table1,MIN(IF(Table1[Temperature]>35,ROW(Table1[Temperature]),999999))-1,2)


You might want to wrap your formula with

=If(Max(Table1[Temperature]) >=35, Formula , "")

You may need to enter this using Ctrl Shift Enter. The 2 at the end of the table tells excel to return the value in column 2 of the table.

=If(Max(Table1[Temperature]) >=35, INDEX(Table1,MIN(IF(Table1[Temperature]>35,ROW(Table1[Temperature]),999999))-1,2) , "")


Yes that worked for me.

[will.sf]

Will. Do you have 365?

I believe so yes, I think this is Excel version 16.

[will.sf]

Hi Mehmetcik, that works perfectly. I'll play around with both formulas you suggested.

Thats the second time you've helped me out this week, thanks so much