If function comparison

Hi,

In the file attached, there is the Group column (B) and Name column (C) both of which are related to each other. I need a formula that would return a value under certain conditions of what is inside columns B and C.

If e.g. the column B value is USA, but in column C we have "wood and metal" for group USA, then I need column D (Result) return "USA", same rule would apply for China. If I am trying to to get a result from groups - France, Greece, and Italy; then I want to return what is in Column C (oil,metal, TV) into column D


Group Name Result
USA wood
USA metal
France oil
Greece metal
Italy TV
Italy TV
Italy TV
China cotton
China fruit
China paper
China engine


P.S. s

Hi,
I created in column A column a combination of columns B & C
Then in column D (result) I applied the following formula to extract the country name:

=+LEFT($A2,FIND("_",$A2,1)-1)

This formula can be copied down to entire column.

Thank you very much!