Need help creating search function of list

Hi everyone! I am new to this forum. I would really appreciate your help!

See below for my example (comments further help to explain what I am trying to do; link to image also at very bottom). I am trying to program a search function in F4. When a user inputs a last name into this cell, the formulas (starting in F6 and continuing downward) should read the cells in C5 downward. Each time the last name matches, the list on right will display the project name the person is working on (i.e. what corresponds in column B).

This is to help me keep track of projects we have assigned to various people, and to see what projects people are working on. Again, would really appreciate your help.

Lastly, I want to do this without using VBA.

THANK YOU!

Example.jpg