满足两个条件的查找函数

fangmeijiao

同时满足两个条件的查找函数，查找出固定时间段内所有数据


请看附件

感谢帮忙

晨光晞微

1. =INDEX(E:E,SMALL(IF(IFERROR(VDB(,,"2024/"&TEXT(-1%,SUBSTITUTE(E$3,"-",";")),"2024/"&TEXT(1%,SUBSTITUTE(E$3,"-",";")),H$14:H$99)+1,)*(K$14:K$99=D$3),ROW($14:$99),4^8),ROW(A1)))&""

复制代码

低版本跑火车

我的城市你来过

=TEXTSPLIT(TEXTJOIN(",",,IF(($H$14:$H$29>TEXT(2024&"/"&INDEX(TEXTSPLIT(E3,"-"),1),"yyyy-mm-dd")/1)*($K$14:$K$29=$D3)*($H$14:$H$29<=TEXT(2024&"/"&INDEX(TEXTSPLIT(E3,"-"),2),"yyyy-mm-dd")/1)=1,$E$14:$E$29,"")),,",")