I would like a FORMULA that change letters according to table of values that i make.
example:
êíöä = LOVE (because i made a table that show: ê=L, í=O, ö=V, ä=E).
example- Picture:
As you can see in the picture above,
AB1 - the word I want to decode.
AB2 - the end result that I want to get.
Note: The result is obtained by replacing all the letters in AB1 cell according to the table in A1:Z2.
Thank you. Appreciate your help..
example:
êíöä = LOVE (because i made a table that show: ê=L, í=O, ö=V, ä=E).
example- Picture:

As you can see in the picture above,
AB1 - the word I want to decode.
AB2 - the end result that I want to get.
Note: The result is obtained by replacing all the letters in AB1 cell according to the table in A1:Z2.
Thank you. Appreciate your help..
Last edited: