I have created a validation drop down list but because the list can be quite
long I want to be able to type a specific word on the cell that would
associate that specific item in the drop down list.

For example, lets say my drop down list contains the months of the year from
January to December. I want to associate 1 = January and 2 = February and so
on so that when I enter 6, June comes up on the cell.

Does anyone know if this is possible on Excel?