Extract Values into Column F if Condition is Met

Looking for formula (non-array preferred) to look into column A in sheet named House, column A and column E in sheet named Here and extract desired values into column F. Values to be extracted into column F is based on the selection in C2 of sheet named House.

See attached sample file.

Example:
If C2= First Name (sheet named House)
Extracted values into column F of sheet named Here would be (since it satisfies the requirement for First Name selection in C2:
Ah, John
Ah, John

If C2= Last Name (sheet named House)
Extracted values into column F of sheet named Here would be (since it satisfies the requirement for First Name selection in C2:
Akon, Oscar
Akon, Oscar
Allan, Ricux
Bankinin, Taco
Bankinin, Taco
Bankinin, Taco
Blue, Sky
Bohn, Luck Anner
Done, Christ
Done, Christ
Done, Christ
Done, Christ
Gonner, James
Hartter, Cross
Hartter, Cross
Hartter, Cross
Karlazo, Ross
Mat, Elalere
Mat, Elalere
McDonald, Mil
McDonald, Mil
McDonald, Mil
McDonald, Mil
Obruko, Han
Stall, Sharp