求助大师，帮帮~

windy_hf

在sheet2中查找经办单位及社保缴纳地，缴纳频率为月度，在大额月缴特殊规则中I到T列找符合核算周期月份的值，并返回对应月份的值，企业返回K列，个人返回L列

gadxjyang

=SUMPRODUCT((Sheet2!$I$2:$T$5)*(Sheet2!$B$2:$B$5=$C3)*(Sheet2!$D$2:$D$5=$B3)*(LEFT(Sheet2!$G$2:$G$5,2)=LEFT(RIGHT(K$1,4),2))*(Sheet2!$I$1:$T$1=MONTH($D3)&"月"))

你是那块小饼干

=TRANSPOSE(CHOOSECOLS(FILTER(Sheet2!$I$2:$T$5,Sheet2!$D$2:$D$5=Sheet1!B3,""),MATCH(MONTH(D3)&"月",Sheet2!$I$1:$T$1,0)))

紫色风信子@

看一下是不是

忙到飞起

=TOROW(CHOOSECOLS(FILTER(Sheet2!$I$2:$T$5,Sheet2!$D$2:$D$5&Sheet2!$B$2:$B$5=CONCAT(Sheet1!B3:C3)),MATCH(MONTH(D3)&"月",Sheet2!$I$1:$T$1,)))
写的不好，下拉

mykitami

=INDEX(Sheet2!$I$2:$T$5,MATCH($B3&$C3&LEFT(RIGHT(K$1,4),2)&"部分",Sheet2!$D$2:$D$999&Sheet2!$B$2:$B$999&Sheet2!$G$2:$G$999,),MATCH(MONTH($D3)&"月",Sheet2!$I$1:$T$1,))