在Sheet2的C2单元格输入以下公式,然后向下填充公式
=LOOKUP(1,0/((Sheet1!B$2:B$20=A2)*(Sheet1!C$2:C$20=B2)),Sheet1!A$2:A$20)
在Sheet2的D2单元格输入以下公式,然后向下填充公式
=LOOKUP(1,0/((Sheet1!B$2:B$20=A2)*(Sheet1!C$2:C$20=B2)),Sheet1!D$2:D$20)
追问数据总量有40,000多行,套用你的公式吧B$2:B$20改为 B$2:B$42220,报错,哪出问题了?