Built 2019 NBA Draft Database. built dropdown combo-box for all players. need 1 more thing

So i have built a database of the 2019 NBA draftees and their raw stats. For what I want, it is almost complete. Its essentially consists of raw data from basketball-reference.com and other type of sites. Yesterday, I finished inputting a "google-like" drop-down combo box to search by player name. The combo box works great. as i am typing in a players name, the more i type, the smaller the drop down for names becomes, until eventually, i find the player that I am looking for and click it.

This issue is, is when i select the player, nothing happens. i need it to where once i select the name and press/click enter, it jumps me straight to the cell where the players name actually is. I have a column named "players". to the right of each player has all of their raw stats, so its just a matter of somehow telling excel that when you select a name from the drop down, or you completely disregard what is being shown in the drop down and you simply finish typing out the full name and hit enter, that it directs me to that players name in their associated cell, under the column listed as "player".

I wouldn't call myself a Noob, but this issue i have is troubling me to a fair degree. Here are some screenshots below that should give you a better idea as to what I am talking about.
201 nba database main issue explained.JPG

NOTE: I HAVE ADDED A SAMPLE WORKBOOK. PLEASE LET ME KNOW IF THE WORKBOOK WORKS FOR YOU OR IF YOU HAVE AND QUESTIONS, COMMENTS OR CONCERNS REGARDING IT AND i WILL GLADLY TAKE ALL HINTS, TIPS. AND CONSTRUCTIVE CRITICISM IN ORDER FOR MY ISSUE TO BE SOLVED. THANK YOU FOR TAKING THE TIME TO READ THIS TODAY.

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)