Return true if all values are found in an array

[yinkajewole]

How can i return as true when all my values are all found in an array?

 

[theBardd]

Assuming your array is in A1:A6, and the values in B1:B3, you could use this array formula

=COUNT(MATCH(B1:B3,A1:A6,0))=COUNT(B1:B3)

 

[yinkajewole]

Assuming your array is in A1:A6, and the values in B1:B3, you could use this array formula

=COUNT(MATCH(B1:B3,A1:A6,0))=COUNT(B1:B3)

i'm sorry, i mean in vba

 

[theBardd]

In VBA, do you want it as part of a bigger routine, or do you want a UDF that returns true or false to the worksheet.

 

[yinkajewole]

i like to have it as a function as boolean

 

[theBardd]

Public Function MatchAll(ByRef Target As Range, ByRef Values As Range) As Boolean
Dim cell As Range

    MatchAll = True
    For Each cell In Values.Cells
    
        If IsError(Application.Match(cell.Value, Target, 0)) Then
        
            MatchAll = False
            Exit Function
        End If
    Next cell
End Function