Finding a value after multiple conditions

Hello,

I want to find the value after several conditions.

Column A contains a list of names.
Column B contains a value
In column C is the hobby.

Column E contains the same list of names.
Column F contains the same list of value.
And I want to get the corresponding value from column C into column G.


If this value in column E is present in column A, then check the value in column F in column B. After that, return the value in column C.


F 120 Soccer-------------F 120 ?
F 110 Handball----------F 110 ?
F 828 Basketball---------F 828 ?
F 100 Baseball-----------F 100 ?
F 500 Baseball-----------F 500 ?
J 100 Soccer-------------J 100 ?
J 500 Soccer-------------J 500 ?
J 323 Soccer-------------J 323 ?
J 543 Basketball---------J 543 ?
J 235 Baseball-----------J 235 ?
R 457 Hockey------------R 457 ?
R 346 Baseball-----------R 346 ?
R 234 Basketball---------R 234 ?
R 879 Soccer-------------R 879 ?
R 463 Soccer-------------R 463 ?

Thank you.

Great, it works. You helped a lot. Thank you very much.