Create an array for matches of a source array to any values in a match array.

[drew.j.harrison]

I'm looking to identify all rows in a range that match any values from another dynamic range that can have a varying number match values. Need to get all matches to remain 0 and all non matches to go to 1. Below is the current code I am using but it does not evaluate it as single array as I was hoping.

{IF(DATA_RANGE=TRANSPOSE(MATCH_VALUES_RANGE),0,1)}

Below is an example of what the two input ranges would be and the output I am looking for. Thanks for the help.

MATCH_VALUES_RANGE
1
2
3

DATA_RANGE
1
7
2
9
3

DESIRED ARRAY RESULT
0
1
0
1
0


CROSS POST
https://www.mrexcel.com/forum/excel-...ml#post5014390