Forum Discussion
Change numbers in column to text
Paul, let me illustrate on this simple model
Even better to use Table for the mappings, it's easier to support and not necessary to adjust formulas for expanded ranges or use dynamic ranges formulas.
That could be like
if we name the table as shopNames.
Please check in attached file.
Thanks for your answer.
I created a table with our shops and try to use the formula.
It fails, how should i use this formula?
=index(matrix with shops;match(number;numbers of shops;0))
I get the result of the shops in a row, but it doesn't convert the numbers into the name of the shops. What am i missing?
Greetings,
Paul
Paul, let me illustrate on this simple model
Even better to use Table for the mappings, it's easier to support and not necessary to adjust formulas for expanded ranges or use dynamic ranges formulas.
That could be like
if we name the table as shopNames.
Please check in attached file.
Paul, glad to help