Monday, August 13, 2012

yogi_Set Up A Word Code Table For Customized Dictionary Or Encryption

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #693   Aug 13, 2012

user TraditionalPanda said: (!category-topic/docs/spreadsheets/KUZBzidZjhI%5B1-25%5D)
Search Column A for a word and display Column B for that row in Column D based on user input in Column C 
I'm trying to type a word into column C and then have it perform a search on Column A and display the corresponding Column B entry, either one word at a time or concatenated.
It's a rudimentary translator for a language that does not exist in Google Translate. This is all text; columns are formatted as text only.

Column A    Column B
journey     s^`My5($ 
is          `B£
half        9Cje
following is a solution to a bit more generalized problem