How to show proper name when using an abbreviation
Hopefully someone can help me.
We are using a lot of abbreviations but also need the proper name. Because this is a recurring thing in different sheets I would like to create a kind of “master sheet” where the data can be pulled off. But I do not have an idea which kind of formula to use.
If it is not possible that the data can be pulled off one master sheet, I would much appreciate a hint to which formula I should use in the sheets themselves.
Also we are using forms in all kinds of sheets, just in case that is a problem to consider.
Thank you in advance for your help.
Help Article Resources
Check out the Formula Handbook template!