how to compare two columns and return a value (probably a VLOOKUP issue?)

[quirk]

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.

[NBVC]

Will this work?

=IF(COUNTIFS(D$2:D2,D2,G$2:G2,G2)=1,MAX(H$1:H1)+1,INDEX(H$1:H1,MATCH(1,INDEX((D$1:D1=D2)*(G$1:G1=G2),0),0)))

copied down

[quirk]

Thanks very much NBVC! This will work perfectly.