title: Google Sheets multiple search and replace from a list
body: <p>I am looking for a solution to search for certain strings in a Google Sheet and, when found, replace them with another string from a list in another sheet.</p>
  
  <p>For better understanding, I prepared a Sheet for you: </p>
  
  <p><a href="https://docs.google.com/a/vicampo.de/spreadsheets/d/1mETtAY72K6ST-hg1qOU9651265nGq0qvcgvzMRqHDO8/edit?usp=sharing" rel="noreferrer">https://docs.google.com/a/vicampo.de/spreadsheets/d/1mETtAY72K6ST-hg1qOU9651265nGq0qvcgvzMRqHDO8/edit?usp=sharing</a></p>
  
  <p>So here's the exact task I want to achieve: </p>
  
  <p><em>In every single cell in column A of sheet "Text", look for the strings given in column A in sheet "List" and, when found, replace it with the corresponding string in column B of the sheet "List".</em> </p>
  
  <p>See my Example: Look in cell A1 for the string "Lorem" and replace it with "Xlorem", then look for the string "Ipsum" and replace it with "Xipsum", then look for the string "amet" and replace it with "Xamet" then move on to cell B1 and start again looking for the strings...  </p>
  
  <p>I have tried different functions and managed to do this with a function for one cell. But how to do it in a loop?</p>
  
  <p><strong>Thanks everyone</strong> who is interested in helping out with this problem!</p>