Formula to find Mis-Matches in two arrays of varying size

[CodeNinja]

Good afternoon,
I am trying to figure out a formula that returns true/false on two array saying if they match. A simple example of what I want is as follows:

Array1: {"A", "C", "D"}
Array2: {"A", "B", "C", "D", "E"}

Desired result: {True, False, True, True, False}

Using ={"A", "C", "D"}={"A", "B", "C", "D", "E"} will result in {TRUE,FALSE,FALSE,#N/A,#N/A}

How do I get an unknown set of strings to line up properly.... Obviously my arrays are more complicated than A, B, C...

Thanks,

CodeNinja

 

[Joe4]

The question is which array are you comparing to the other?
I mean, are you checking to see if the values in Array1 are in Array2, or vice versa?

If you are trying to do both ways, your desired result doesn't really make any sense, as what if your two arrays were:
Array1: {"A", "C", "D"}
Array2: {"X", "Y", "Z"}
Then what would your results look like? Would they have three items or six?

I think what you want to do is loop through the items of one array, and see if it is found in the other.
See here for a VBA function someone may to do that: https://wellsr.com/vba/2016/excel/check-if-value-is-in-array-vba/