根据定价范围 找出数字 (9273)


H2=LOOKUP(1,0/(A$2:A$18=E2)/(LEFT(B$2:B$18,FIND("-",B$2:B$18)-1)-F2<=0),C$2:C$18)


留言