查询员工信息表中所有人事信息

pureshadow

=IF(COUNTIF($A:$A,$G$1),VLOOKUP($G$1,$A$1:$D$9,COLUMN(A1),0),OFFSET(A$1,SMALL(IF($B$2:$B$9=$I$1,ROW($1:$8),9),ROW(A1)),))&""
ctrl+shift+enter