I need to use the Table1 table to find the pressure loss per pipe size and flow rate. The below method works well if there is there is an exact match but I need the match on Flow rate to be exact or else the next biggest size.

Its finding the next biggest size, but cant get it to return the next biggest size for the relevant pipe size.

=(FILTER(Table1[PresureLoss],(Table1[PipeSize]=B20)*(Table1[FlowRate]=(INDEX(Presure!A:C,XMATCH(A20,Presure!C:C,1,1),3)))))*C20

Link to file is below.