Here is a sample of the data.

Condition 1 Condition 2 Condition 3 Type
Problem A Type A
Problem B Type B
Problem C yes no
Type B
Problem C yes yes
Type B
Problem C no yes
Type C

Based on Conditions 1, 2 and 3 I want to fill out Type A, B or C in the
forth column. So the logic would be

If condition 1 = Problem A then Type A
If condition 1 = Problem B then Type B
If condition 1 = Problem C and Condition 2=yes and condition 3 = no then
Type B
If condition 1 = Problem C and Condition 2=yes and condition 3 = yes then
Type B
If condition 1 = Problem C and Condition 2=no and condition 3 = yes then
Type C