Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #693 Aug 13, 2012 www.energyefficientbuild.com.
user TraditionalPanda said: (http://productforums.google.com/forum/?zx=76albpq7qu02#!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.
user TraditionalPanda said: (http://productforums.google.com/forum/?zx=76albpq7qu02#!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.
Example:
Column A Column B
journey s^`My5($
is `B£
half 9Cje
------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem
