I'm trying to set up a feature in my workbook where a user can select an acronym anywhere on a spreadsheet and cell A1 will display the acronym selected. I'm planning to use the acronym appearing in A1 to display the spelled-out name in B1 via a lookup table.
For example, I'd like to set A1...