title: if a cell (Column A) contains a value/string from column B, then write value/string in column C
body: <p>In Google Sheets I have a list of keywords in Columns A, like the following:</p>
  <p>ferrari blue 1975<br />audi 1988 white<br />black bmw 1989</p>
  <p>then I have in Column B car brands, column C colors, column D years.</p>
  <p>I want to check if a keyword (column A), contains a certain car brand (column B) to write in a another Column the value matched.
  The same then for colors and years.</p>
  <p>Can you please help?
  Thanks</p>