DLOOKUP满足双条件如何写代码

juanchan

你好,请问用DLOOKUP要满足两个条件来查找返回一个内容,请问该怎么写代码?

Public Function DLookupNumberWrapper(Expr As String, Domain As String, Optional Criteria As String, Optional ValueIfNull = 0) As Variant
    DLookupNumberWrapper = Nz(DLookupWrapper(Expr, Domain, Criteria), ValueIfNull)
End Function

请帮忙看看下面该怎么改
Function Get33CheckoutSN(Sn As Long, Code As Long)
    Get33CheckoutSN = DLookupNumberWrapper("[33#]", "材料未出库领用查询", ("[新流水号]=" & Sn And "[材料编码]=" & Code))
End Function