自定义
Option Compare Text
Function bl(t As Range, ref As Range, ic As Integer, i As Integer) As String
If t.Count > 1 Or Len(t.Value) = 0 Then Exit Function
If ref.Rows.Count > 1 Then Exit Function
If ic > ref.Columns.Count Then Exit Function
Dim arr
arr = Split("-" & t.Value, "-")
If i > UBound(arr) Then Exit Function
If arr(i) = ref(1, ic).Value Then
bl = arr(i)
Else
bl = ""
End If
End Function