Forum Discussion
Solved
INDEX...retrun the closesed value
I try to have returned the value coming most closeley to the value in the matrix: Specifically, I try to define an insulation thickness of the pipe, depending on diameter and operating temperature :...
=INDEX($C$2:$I$11,MATCH(B15,$B$2:$B$11,0),MATCH(B16,$C$1:$I$1,-1))
Maybe with this formula as shown in the attached file.
=INDEX($C$2:$I$11,MATCH(B15,$B$2:$B$11,0),MATCH(B16,$C$1:$I$1,-1))
Maybe with this formula as shown in the attached file.
- thank you! 🙂
