The attached file has the sample setup to illsutrate the problem. There is also a large blue box on the tab explaining the goal. I am not repeating the same description here as it would be unnecesssary duplication of effort but at the high level this is about having a cell which could predict what is being typed in by comparing to another range of data then autocompletes that entry in the cell. The list that is provided on file displays the methods that can be used to achieve this goal but are not acceptable. Therefore it warrants a custom VBA solution to achieve this goal.