I have a list of players located on the sheet ' Players'. When I start to enter one of those players on the sheet 'Draft Board', I want the closest name to populate so it can quickly be entered. Is that possible in excel. I've tried a few different ways but nothing will work. At this point I'm not looking for direction but hope someone can help with a solution. Thank you for your help in advance. See attached.
Bookmarks