2024-10-18 06:43:21
在I5中输入或复制粘贴下列公式
=IFERROR(INDEX(A2:A7,MATCH(I3,OFFSET(A2:A7,,MATCH(I2,B1:G1,)),)),"无此组合")
2024-10-18 07:31:56
以图为例,数据在A1:G8区域,条件在I2/J2
K2=INDEX(A1:A8,SUMPRODUCT((B1:G1=I2)*(B2:G8=J2)*ROW(B2:G8)))
2024-10-18 05:57:38
2024-10-18 05:59:03
2024-10-18 06:46:48