Hello all!
Any ideas how to modificate below code to search using two criterias, first as it is from CSV column, and second single value from another?
Any ideas how to modificate below code to search using two criterias, first as it is from CSV column, and second single value from another?
Code:
Function SplitLookup(myTxt As String, myTable As Range, myColumn As Integer) As String
arrValues = Split(myTxt, ",")
For Each Item In arrValues
mtch = ""
On Error Resume Next
mtch = Application.VLookup(Item, myTable, myColumn, False)
If IsError(mtch) Then mtch = "0"
On Error GoTo 0
If mtch = "" Then mtch = "0"
Res = Res & mtch & ";"
Next
Res = Left(Res, Len(Res) - 1)
SplitLookup = Res
End Function