Tooltip Look Up - Mouseover or Click

I'm looking at condensing a wide worksheet, 100 columns of specific location names, into something more aesthetically pleasing.

I have a list that contains a location name and it's corresponding acronym. When a user mouses over the acronym on the worksheet with the 100 columns I'd like for the location name to display. I've mocked up an example and attached it.

Furthermore, is there a non VBA solution. I tried searching for lookups and data validation to no avail.


I feel that clicking into the cell and the tooltip displaying may be easier for our end user; however, share your thoughts.

Thanks!