迷人丶 发表于 2021-11-11 11:56:00

根据对应条件返回对应值

需要用两个条件：条件1大于40，条件2小于70分，和G列数据对比，将G列的值满足该条件：40




大逊 发表于 2021-11-20 19:19:02

C2 公式下拉
=INDEX(Sheet2!C:C,SMALL(IF((Sheet2!$G$2:$G$10>40)*(Sheet2!$G$2:$G$10<70),ROW($G$2:$G$10)),ROW(A1)))

总动员 发表于 2021-11-30 22:52:39

=IFERROR(INDEX(Sheet2!C:C,AGGREGATE(15,6,ROW($2:$10)/((Sheet2!$G$2:$G$10>40)*(Sheet2!$G$2:$G$10<70)),ROW(A1))),"")

这跟上一题不是一样的吗

惠三少 发表于 2022-2-13 05:29:40

根据字面理解不知对不对？
=IF((Sheet2!G2>40)*(Sheet2!G2<70),Sheet2!$C2,"")
或
=INDEX(Sheet2!C:C,SMALL(IF((Sheet2!$G$2:$G$10>40)*(Sheet2!$G$2:$G$10<70),ROW($2:$10),99),ROW(A1)))&""
页: [1]
查看完整版本: 根据对应条件返回对应值