gene|fish

=IF(AND(A2=1,B2=2),1,IF(AND(A2=1,B2=1),2,IF(AND(A2=2,B2=1),3,IF(AND(A2=2,B2=2),4,0))))