Return Array where value in another Array.

[ko1967]

I have an array (lets call it Array1) and another array (lets call it Array2) as follows.

Array1 = {A,B,C,D}
Array2 = {A,C}

I'm trying to return an array (same length as Array1) where the value will be true if the item in Array1 is found in Array2.

Essentially from the above I want to return {TRUE, FALSE, TRUE, FALSE} because A and C are in Array2 and B and D are not. Every solution I've tried returns an array of 2 elements not 4. I'm on office 365 so I have access to all the new dynamic array functions.

Thanks.

 

[Fluff]

My pleasure

 

[Rick Rothstein]

What I provided was a very simple example of a more complex problem.

Something for you to keep in mind (a canned response)...

For future questions you may ask, please do not simplify your question for us... doing so will get you a great answer to a question you do not actually have and which you do not actually care about AND it will almost always lead to you coming back for help when the solution we give you for the simplified question cannot be applied to your actual data and its layout. One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data, absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result... you must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data).