Trying to create an intuitive excel spreadsheet. Essentially, I've a list of abbreviations, and want to have a separate list display text based on said abbreviation
E.g:
If Abbreviation = Q1, display "Quarry 1" in Location.
If Abbreviation = A1, display "Axel 2" in Location
and so on and so forth...
I'm unsure of which the best function would be to incorporate this. My list of abbreviations total ~10, with ~10 total location outputs.
I'm aware I could just add a drop down to each "Location" cell but wanted to try to make it automated
Any help is greatly appreciated
E.g:
If Abbreviation = Q1, display "Quarry 1" in Location.
If Abbreviation = A1, display "Axel 2" in Location
and so on and so forth...
I'm unsure of which the best function would be to incorporate this. My list of abbreviations total ~10, with ~10 total location outputs.
I'm aware I could just add a drop down to each "Location" cell but wanted to try to make it automated
Any help is greatly appreciated