I am looking for a formula that would make my life much easier. I have a table with simple coordinates in the columns and coordinate combinations in the rows. I want Excel to indicate when a coordinate is included in the coordinate pairs. The output should be 0 and 1 (see picture). I was thinking of a If function, but I didn't know how to implement it.
My example has a total of 13 different coordinates, so you can imagine how much work this would be by hand.
