查询专题
=VLOOKUP(A17,B1:G12,COLUMNS(B1:G12),)

=VLOOKUP(1,IF({1,0},0/($B$2:$B$12=A17),$G$2:$G$12),2)

=LOOKUP(1,0/($B$2:$B$12=A17),$G$2:$G$12)

=INDEX(G:G,SMALL(IF($B$2:$B$12=$A17,ROW($B$2:$B$12)),3))

=IFERROR(INDEX(G:G,SMALL(IF($B$2:$B$12=$A$17,ROW($B$2:$B$12)),ROW(A1)))&"","")

=VLOOKUP(A17&"|"&B17,CHOOSE({1,2},$B$2:$B$12&"|"&$D$2:$D$12,$G$2:$G$12),2,0)

=LOOKUP(1,0/($B$2:$B$12=A17)/($D$2:$D$12=B17),$G$2:$G$12)

=INDEX($A$1:$G$12,RIGHT(MAX(IF($B$2:$B$12="张三",ROW($B$2:$B$12)+$G$2:$G$12/1%%%)),3),COLUMN(C1))

=INDEX($C$2:$C$12,MATCH(A17,$D$2:$D$12,))

=LOOKUP("座",OFFSET($A$2,,,MATCH($A$17,$B$2:$B$12,)))

=COUNTA(INDEX($C$1:$C$13,LOOKUP(1,0/(LOOKUP(ROW($2:$13),IF($B$2:$B$13<>"",ROW($2:$13)),$B$2:$B$13)="A公司"),ROW($2:$13))):INDEX($C$1:$C$13,MATCH("华北区域",$A$1:$A$13,)))




赞 (0)