I use spreadsheets a lot to fill in supplies I receive. I wanna know if there is a way to type a catalogue number (which is shorter than the product name) in a cell then once you press [Enter] or leave the cell it replaces it with the product name.
For Example the Catalogue number for the product “Plastic Bandage” is PY420:
When I type PY420 in a cell and press [Enter] it changes to “Plastic Bandage”
Sort of like an autocomplete dictionary.