Multiple and changable codes/information in one cel
I'm trying to create a formula wich allowes me to use abbreviations for
company names and their credit number.
Something like: If I put "st" in a cell, the next cell will contain the full
name of the company and their number.
but, when I want to type "bn" in the same cel (deleting the "st" ofcourse)
the next cell will contain the full name and number of that company.
And so on for like fifthy different company names.
Is there any way to do this?
Yours,
Roy Nederend
the Netherlands
|