二区间求值 (11225)

C10=LOOKUP(1,0/(B10>=VLOOKUP(A10,B$2:H$6,{2,4,6},1)),VLOOKUP(A10,B$2:H$6,{3,5,7},1))

另解C10=LOOKUP(B10,VLOOKUP(A10,B$2:H$6,{2,3;4,5;6,7},1))