I'm trying to return True or False for every instance of a value based on two criteria.
The data I'm working with is the result of an experiment that asked people to identify particular words as they heard someone talking. I have data for each listener and the words they identified in two columns, as in the following image:
Example 2.jpg
I'd like now to create a sheet that populates, for each word, and each listener, whether or not they responded to the word or not, as in the image below.
Example.jpg
I've tried using INDEX and MATCH formulas, but can't get them to work.
I've attached some example data in order to demonstrate what I'm trying to do.
Bookmarks