自定义函数: Function FindX(rng1 As Range, rng2 As Range) Application.Volatile Dim arr, i&, j& arr = Range("a1:f" & Cells(Rows.Count, 1).End(3).Row).Value If rng2.Value <> "" Then For i = 1 To UBound(arr, 2) If arr(1, i) = rng2.Value Then Exit For Next i End If For j = 3 To UBound(arr, 1) If rng1.Value <> "" Then If arr(j, i - 1) = rng1.Value Then FindX = arr(j, i): Exit For End If End If Next j End Function
QGJ8afWD.rar
(10.01 KB, 下载次数: 15)
|