I'm actually building a Database in Excel, where sheets are tables, columns are columns, and row are records, kinda simple for the moment.

I made a function that return a boolean if a record with Value1 and Value2 are already registered on the same Row, to prevent duplicate.

Here's the problem I'm facing : I'm actually doing the same Function for 3 values matching

There must be a way to make it dynamicaly depending on numbers of value from an array. But i'm just stuck on it.

There is my initial code for 2 Values matching

```
Function checkDuplicate(ws As Worksheet, value1 As Variant, value2 As Variant) As Boolean
    Dim rng As Range
    Dim first As Variant

    checkDuplicate= False

    If (ws.Name <> "UI" And ws.Name <> "Lists") Then

        With ws.Range("A:A")
            Set rng = .Find(value1)

            If Not rng Is Nothing Then
                first = rng.Row
                Do
                    If ws.Range("B" & rng.Row).Value = value2 Then
                        checkDuplicate= True
                    End If
                    Set rng = .FindNext(rng)
                Loop While rng.Row <> first
            End If
        End With
    End If
End Function

```

I apologize in case my english is kinda bad, or in case someone already helped another person for the same problem because I didn't find it when I searched.

Any help would be highly appreciated.