Dropdown based on a criterion

Hello, I'm looking to create a dropdown list that only suggests a contact's name based on the client code entered in a cell. It should be simple, but I'm having trouble unless I resort to a complicated setup.
Could someone help me?