Hi all,
I am trying to compare two columns--one includes 4 types of stimuli (angry, happy, surprise, disgust) with another column which includes 6 possible responses (same 4 affects and 'none' or 'other'). I want to generate a unique value (1 thru 24) for each possible combination in the next column. For example (in my attached file), column D2: angry, column G2: angry, than H2: 1, if column G were disgust then return 2, etc.
I believe I have too many conditions for an if (and) function and should probably use a VLOOKUP procedure? Any nudges in the right direction would be most welcome! I've attached a sample file.
Bookmarks