Eric_f765 发表于 2014-1-6 22:54 ![](static/image/common/back.gif)
老师好像还是不对,看下面最后一条记录,谢谢。 - =INDEX(OFFSET(INDIRECT("备件号!C"&MATCH(D2,备件号!A$2:A$23,)+1),,,COUNTIF(备件号!A$2:A$23,D2)),MATCH(MIN(ABS(OFFSET(INDIRECT("备件号!H"&MATCH(D2,备件号!A$2:A$23,)+1),,,COUNTIF(备件号!A$2:A$23,D2))-B2)),ABS(OFFSET(INDIRECT("备件号!H"&MATCH(D2,备件号!A$2:A$23,)+1),,,COUNTIF(备件号!A$2:A$23,D2))-B2),))
复制代码 一点小失误公式修改过了
根据时间段查找2.rar
(617.39 KB, 下载次数: 33)
|