请大神帮忙，多个条件匹配问题

阳光小院

PQ解法参考一下

清溪流萍

Sub test()
  Dim i%, j%, k%, arr, d
  Set d = CreateObject("Scripting.Dictionary")
  arr = Sheet1.[a1].CurrentRegion
  For i = 2 To UBound(arr)
  For j = Val(Split(arr(i, 2), "-")(0)) To Val(Split(arr(i, 2), "-")(1))
    For k = Val(Split(arr(i, 4), "-")(0)) To Val(Split(arr(i, 4), "-")(1))
      d(arr(i, 1) & "," & j & "," & arr(i, 3) & "," & Format(CStr(k), "00")) = arr(i, 5)
    Next
  Next
  Next
  arr = Sheet1.[g1].CurrentRegion
  For i = 2 To UBound(arr)
  arr(i, 5) = d(arr(i, 1) & "," & arr(i, 2) & "," & arr(i, 3) & "," & arr(i, 4))
  Next
  Sheet1.[g1].CurrentRegion = arr
End Sub

来不及许愿的流星

太复杂了，不适合我这种初学者啊

李元芳

=VLOOKUP(H2&I2&J2,IF({1,0},RIGHT($B$2:$B$9,2)&$C$2:$C$9&RIGHT($D$2:$D$9,2),$E$2:$E$9),2,0)
三键下拉另外你的数据源中没有满足的条件

坦荡仁生

=IFERROR(LOOKUP(1,0/((RIGHT($B$2:$B$9,2)=H2&"")*($C$2:$C$9=I2)*(LEFT($D$2:$D$9,2)=J2)),$E$2:$E$9),"")

雷艺教育科技有限公司

有点长。。。
=LOOKUP(1,0/(A$2:A$9=G2)/(H2>=--SUBSTITUTE(LEFT(B$2:B$9,2),"-",))/(C$2:C$9=I2)/(J2>=--SUBSTITUTE(LEFT(D$2:D$9,2),"-",)),E$2:E$9)

兴辉陶瓷六哥

楼主装了个陷阱
=LOOKUP(1,0/(A$2:A$9=G2)/(H2>=--SUBSTITUTE(LEFT(B$2:B$9,2),"-",))/(C$2:C$9=I2)/(-J2<=-SUBSTITUTE(LEFT(D$2:D$9,2),"-",)),E$2:E$9)

乐在旅途

按照原数据显示全部房号，在用公式，原数据有变动，刷新数据连接
房屋售价.rar (23.93 KB, 下载次数: 13)

2021-11-23 16:10 上传

点击文件名下载附件
房屋售价.rar

小格影像

谢谢回复。我的表格数据比较多，列出所有房号的方法不适用，不过还是非常感谢

淡淡静海

=VLOOKUP(H2&I2&J2,IF({1,0},RIGHT($B$2:$B$9,2)&$C$2:$C$9&RIGHT($D$2:$D$9,2),$E$2:$E$9),2,0)
三键下拉另外你的数据源中没有满足的条件