建议单价和查询放在同一工作薄中: D2=IF(A2="","",INDEX(Sheet1!C:C,MATCH(1,(--LEFT(Sheet1!A$2:A$100,FIND("至",Sheet1!A$2:A$1000)-1)<=A2)*(--MID(Sheet1!A$2:A$1000,FIND("至",Sheet1!A$2:A$1000)+1,9)>=A2)*(--LEFT(Sheet1!B$2:B$1000,FIND("至",Sheet1!B$2:B$1000)-1)<=B2)*(--MID(Sheet1!B$2:B$1000,FIND("至",Sheet1!B$2:B$1000)+1,9)>=B2),)+1)) 数组公式。
oHNPOT2S.rar
(2.99 KB, 下载次数: 8)
|