= LET(
selectedPressureCase, XLOOKUP(@PressureCase, Data[#Headers], Data ),
temperatureBand, XLOOKUP(@Temperature, Data[Temperature], Data[Temperature], ,{-1,1}),
pressureBand, XLOOKUP(@Temperature, Data[Temperature], selectedPressureCase, ,{-1,1}),
interpolatedPressure, TREND( pressureBand, temperatureBand, @Temperature ),
interpolatedPressure )
= TREND(
LARGE(IF(Data[#Headers]=@PressureCase,Data), MATCH(@Temperature,Data[Temperature])+{0,1}),
INDEX(Data[Temperature], N(IF(1,MATCH(@Temperature, Data[Temperature])+{0,1}))),
@Temperature)
= TREND(
LARGE(IF(Data[#Headers]=@PressureCase,Data), MATCH(@Temperature,Data[Temperature])+{0,1}),
INDEX(Data[Temperature], MATCH(@Temperature, Data[Temperature])+{0,1}),
@Temperature)
Out of curiosity why was the coercion needed?