Vlookup Based On 2 Condition

i looking for function, which will give me a results if its the person good , bad and other (Y). It will look based on column A, but if will be more equal names in this column, it looks in the column surname (B) and return value from column (Y) in this row. But it can be more equal column B.

Here is an example:
Results what i want are in Z1,Z2,Z3

X Y Z
1 sue doe good
2 joe bond very good
3 mark no bad

SOURCE table
A B C
1 john doe good
2 joe black bad
3 sue doe good
4 mark black not bad
5 joe bond very good
6 mark no bad
7 kat doe bad